Job Description

Pune, IN-MH
Position Type
Full Time


Requisition ID
12401


Level of Education
3 Year Degree or equivalent


Years of Experience
7+ to 10 Years

About Exela

Exela is a business process automation (BPA) leader, leveraging a global footprint and proprietary technology to provide digital transformation solutions enhancing quality, productivity, and end-user experience. With decades of expertise operating mission-critical processes, Exela serves a growing roster of more than 4,000 customers throughout 50 countries, including over 60% of the Fortune 100. With foundational technologies spanning information management, workflow automation, and integrated communications, Exela's software and services include multi-industry department solution suites addressing finance & accounting, human capital management, and legal management, as well as industry-specific solutions for banking, healthcare, insurance, and public sectors. - Through cloud-enabled platforms, built on a configurable stack of automation modules, and 17,500+ employees operating in 23 countries, Exela rapidly deploys integrated technology and operations as an end-to-end digital journey partner.

Sr. SQL Server Database Administrator

Roles and Responsibilities:

Collaborate closely with Application Developers to design, test, implement, optimize, and maintain efficient transactional and analytical data models. Lead and engage in tuning, upgrade, and configuration projects to enhance database performance and ensure stability. Optimize and manage backup jobs and schedules, while maintaining Production, Disaster Recovery (DR), and Development environments. Troubleshoot database and data-related issues as they arise. Provide ad-hoc data reporting and data extraction for Analytics teams. Perform various ad-hoc data loading and manipulation tasks as needed. Manage routine data exports for clients, partners, and Subject Matter Experts (SMEs). Create and manage scheduled tasks and data processing scripts. Document data collection, processing, and presentation procedures. Support the architecture and process flow diagrams for data systems. Participate in the evaluation, design, implementation, maintenance, support, and enhancement of sophisticated database systems and technologies. Manage all levels of database security and integrity, including transaction activity and utilization. Define and document policies, procedures, and standards related to database administration. Troubleshoot database issues, perform recovery, tune the database, install software, and resolve SQL Server errors and failures. Facilitate database backup and recovery, documenting and testing all backup and recovery procedures. Ensure service level availability for all production and non-production SQL Server environments.

Required Technical and Professional Expertise:

Set up Test, Development, Staging, and Production environments, including SQL Server installation.

Implement Disaster Recovery strategies.

Create linked servers to SQL Servers and other databases such as Oracle and PostgreSQL, focusing on security and general administration.

Design a comprehensive database backup and restoration strategy, utilizing SQL Server Agent.

Work as part of a team to provide 24/7 support.

Monitor database backups to ensure they are performed regularly using SQL Server Agent.

Recover databases to a specific point in time upon request, following established backup and recovery procedures.

Set up High Availability as part of the Disaster Recovery strategy for databases, including Failover Clustering, Database Mirroring, Log Shipping, Replication, and Always On.

Troubleshoot various issues that arise in day-to-day operations and implement fixes, including monitoring SQL Server error logs and email alerts.

Conduct monitoring and performance tuning at the physical server level, database level, and query level, including creating and maintaining indexes, adjusting memory settings, and monitoring CPU usage and Disk I/O activity.

Document major changes to SQL Servers and apply service packs as necessary.

Disclaimer:

Exela is committed to creating a diverse environment and is proud to be an equality opportunity employer. Qualified applicants will considered for employment without regard to their race, color, creed, religion, national origin, ancestry, citizenship status, age, disability, gender/sex, marital status, sexual orientation, gender identity, gender expression, veteran status, genetic information, or any other characteristic protected by applicable federal, state, or local laws.

Exela recruiters or representatives will only contact you from emails ending with @exelaonline.com, @exelatech.com, @lexicode.com, @rustconsulting.com or @ersgroup.com. We would never ask you for payment or ask you to deposit a check into your personal bank account during the recruitment process.