Senior Database Administrator

AIS InfoSource; Vadodara; On-site; INR 1,800,000 - 3,000,000; Full time

Job summary

AIS is seeking a Senior Database Administrator to lead enterprise database environments, ensure availability, security and performance, and drive disaster recovery and data warehousing initiatives. The role collaborates with developers and analysts to optimize designs and support mission-critical applications.

Ideal candidates have 10+ years in database administration, strong architecture knowledge, and experience with HA, clustering, and migrations.

Qualifications

• Bachelor's degree required in Computer Science, IT, Engineering, or related field.
• 10+ years hands-on experience in database administration and support.
• Experience administering enterprise-level database environments.
• Strong understanding of database architecture, disaster recovery, and business continuity planning.
• Experience supporting mission-critical applications and large-scale databases.
• Knowledge of data governance, security standards, and regulatory compliance requirements.

Responsibilities

• Install, configure, upgrade, patch, and maintain database software to ensure optimal performance, stability, and security.
• Design and implement logical and physical database architectures, schemas, tables, indexes, and relationships aligned with business and application requirements.
• Monitor database performance, identify bottlenecks, and optimize queries, indexing strategies, memory utilization, and storage resources.
• Develop, implement, and regularly test database backup and recovery procedures to ensure business continuity and data protection.
• Manage database security through authentication mechanisms, role-based access control, encryption, auditing, and compliance with organizational policies.
• Ensure data accuracy, integrity, consistency, and availability through validation rules, constraints, replication, and failover solutions.
• Perform capacity planning and storage management to support current and future database workloads.
• Design, implement, and maintain high-availability and disaster recovery solutions including clustering, replication, and failover configurations.
• Manage database changes, schema modifications, and migrations in accordance with established change management processes.
• Proactively monitor database environments, investigate alerts, perform root cause analysis, and resolve incidents within defined service levels.
• Support internal and external audit requirements and ensure adherence to regulatory and compliance standards.
• Maintain comprehensive documentation of database configurations, procedures, recovery plans, and operational standards.
• Collaborate with application developers, business analysts, and technical teams to optimize database design and performance.
• Administer and maintain reporting servers to ensure reliable report generation and distribution.
• Design, develop, and manage enterprise data warehouse environments.
• Establish and manage data archival and retention strategies.
• Lead database server consolidation initiatives to improve efficiency and reduce infrastructure costs.
• Implement encryption controls for Personally Identifiable Information (PII) beyond Transparent Data Encryption (TDE) requirements.

Skills

Database administration

Performance tuning

Backup & recovery

Security & compliance

Data warehousing

Replication & clustering

Documentation

Stakeholder management

Education

Bachelor's degree in CS/IT/Engineering

Tools

Oracle Database

MS SQL Server

Cloud DB certifications

Job description

REPORTS TO: Vice President, Information Technology

ROLE OVERVIEW:

The Senior Database Administrator is responsible for the design, implementation, maintenance, security, and performance optimization of enterprise database environments. The role ensures database availability, integrity, scalability, and compliance while supporting business-critical applications and data management initiatives. The incumbent will lead database administration activities, disaster recovery planning, data warehousing initiatives, and database consolidation projects to support organizational growth and operational excellence.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• Install, configure, upgrade, patch, and maintain database software to ensure optimal performance, stability, and security.
• Design and implement logical and physical database architectures, schemas, tables, indexes, and relationships aligned with business and application requirements.
• Monitor database performance, identify bottlenecks, and optimize queries, indexing strategies, memory utilization, and storage resources.
• Develop, implement, and regularly test database backup and recovery procedures to ensure business continuity and data protection.
• Manage database security through authentication mechanisms, role-based access control, encryption, auditing, and compliance with organizational policies.
• Ensure data accuracy, integrity, consistency, and availability through validation rules, constraints, replication, and failover solutions.
• Perform capacity planning and storage management to support current and future database workloads.
• Design, implement, and maintain high-availability and disaster recovery solutions including clustering, replication, and failover configurations.
• Manage database changes, schema modifications, and migrations in accordance with established change management processes.
• Proactively monitor database environments, investigate alerts, perform root cause analysis, and resolve incidents within defined service levels.
• Support internal and external audit requirements and ensure adherence to regulatory and compliance standards.
• Maintain comprehensive documentation of database configurations, procedures, recovery plans, and operational standards.
• Collaborate with application developers, business analysts, and technical teams to optimize database design and performance.
• Administer and maintain reporting servers to ensure reliable report generation and distribution.
• Design, develop, and manage enterprise data warehouse environments.
• Establish and manage data archival and retention strategies.
• Lead database server consolidation initiatives to improve efficiency and reduce infrastructure costs.
• Implement encryption controls for Personally Identifiable Information (PII) beyond Transparent Data Encryption (TDE) requirements.

SUPERVISORY RESPONSIBILITIES:

• Provide technical guidance and mentorship to junior database administrators and support staff.
• Lead database-related projects and coordinate activities with cross-functional teams.
• Establish database administration standards, procedures, and best practices.

SKILLS:

• Strong expertise in database administration and management.
• Advanced knowledge of database performance tuning and optimization.
• Experience with backup, recovery, replication, clustering, and high-availability solutions.
• Knowledge of database security, encryption, auditing, and compliance requirements.
• Experience with data warehouse architecture and reporting platforms.
• Strong troubleshooting, analytical, and problem-solving abilities.
• Understanding of capacity planning and database infrastructure management.
• Excellent documentation, communication, and stakeholder management skills.
• Experience with database migration and consolidation projects.
• Ability to work in a fast-paced environment and manage critical incidents effectively.

QUALIFICATIONS:

• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
• 10+ years of hands‑on experience in database administration and support.
• Experience administering enterprise‑level database environments.
• Strong understanding of database architecture, disaster recovery, and business continuity planning.
• Experience supporting mission‑critical applications and large‑scale databases.
• Knowledge of data governance, security standards, and regulatory compliance requirements.

LANGUAGE SKILLS:

Ability to read, analyze and interpret the most complex documents. Ability to respond effectively to the most sensitive inquiries or complaints. Ability to write emails, speeches and articles using original or innovative techniques or style. Ability to make effective and persuasive speeches and presentations on controversial or complex topics to top management, public groups and clients.

REASONING ABILITY:

Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.

CERTIFICATES, LICENSES, REGISTRATION:

• Oracle Database Administration Certification (OCP/OCA).
• Microsoft SQL Server Certifications.
• Certified Information Systems Security Professional (CISSP) or equivalent security certification (preferred).
• Relevant cloud database certifications from AWS, Azure, or Google Cloud Platform.

WORK ENVIRONMENT:

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the noise level in the work environment is usually quiet to moderate.

DISCLAIMER:

The information in this job description is designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this position and may be changed at the company’s discretion to conform to business needs.

ABOUT THE COMPANY:

AIS is a Texas-based fintech firm committed to lowering operating costs, improving quality and reducing cycle time with back-office automation, highly skilled talent and standardized reporting and analytics solutions. AIS manages the day-to-day work so our clients can focus on growing their business. We review client processes, eliminate non-value adds, and enhance productivity. We build financial and legal technology to automate and optimize workforce performance. We recruit, train, and manage specialized human resources to meet staff augmentation needs. We equip decision makers with deep data sets and forward-thinking analytics so they can make smarter business decisions and create better customer experiences. We serve a variety of industries including banking, automotive finance, credit card, mortgage, insurance and telecommunications.