Data base Administrator

Location - Remote (India)

Key Responsibilities 

• Design, develop, and maintain database schemas, stored procedures, views, and queries in SQL Server and MySQL. 

• Identify and resolve query performance bottlenecks using execution plans, indexing strategies, and tuning techniques. 

• Conduct regular database health checks and performance reviews to ensure optimal operation. 

• Collaborate with development and operations teams to support application data requirements. 

• Write and optimize complex SQL scripts to meet business and operational needs. 

• Support the DBA Team Lead with day-to-day database operations and incident resolution. 

• Assist in monitoring database availability, integrity, and backups. 

• Document database structures, procedures, and changes in a clear and organized manner. 

• Implement best practices for data storage, retrieval, and processing efficiency. 

• Contribute to the continuous improvement of database standards and internal processes. 

• Identify and effectively prioritize situations requiring urgent attention. 

• Stay current with system information, database technologies, changes, and updates. 

• Experience with cloud-managed databases (e.g., Microsoft Azure SQL Database, Amazon RDS) and understanding of scaling, cost optimization, and high availability in cloud environments. 

• Hands-on exposure to database automation and CI/CD practices (schema versioning, deployment pipelines, Infrastructure as Code). 

• Strong knowledge of high availability and disaster recovery design, including replication, failover, and defined RPO/RTO ownership. 

• Familiarity with database security best practices (encryption, access control, auditing, and protection of sensitive/regulated data). 

• Experience with monitoring and observability tools, with a proactive approach to performance tuning and alerting. 

• Scripting ability (PowerShell, Python, or Bash) to automate routine database operations and reduce manual effort. 

• Experience with database migrations, version upgrades, or modernization initiatives (on-prem to cloud or legacy to current platforms). 

• Ability to operate in a DevOps-oriented environment, partnering closely with engineering teams and owning database performance tied to application SLA. 

• Proficiency in T-SQL and/or standard SQL. 

• Ability to multi-task and adjust priorities quickly in a fast-paced environment. 

• Ability to research and implement solutions using available technical resources. 

• Strong analytical and problem-solving skills with attention to detail. 

• Ability to clearly communicate technical concepts to non-technical stakeholders. 

• Advanced knowledge of database performance tuning and query optimization. 

• Familiarity with cloud database platforms such as Microsoft Azure SQL, AWS   RDS, or equivalent. 

• Experience with database deployment automation and CI/CD pipelines. 

• Understanding of high availability, disaster recovery, and data protection strategies. 

• Working knowledge of database monitoring and performance management tools. 

• Basic scripting skills (PowerShell, Python, or Bash) for automation. 

• Awareness of data security and compliance considerations in regulated environments. 

Required Skills 

• Proven working experience as a Database Administrator or in a similar role. 

• Working knowledge of Microsoft SQL Server (SSIS, T-SQL, DDL, SML) 

• Working knowledge of MySQL or MariaDB. 

• A minimum of 5 years of experience in database administration. 

• Understanding of database normalization and data modeling principles. 

Nice to Have 

• MacOS, iOS, Android, Linux OS beneficial but not required. 

• ETL processes or data warehouse experience beneficial but not required. 

• Microsoft Certified: Azure Database Administrator Associate or equivalent SQL Server certification preferred but not required. 

• MySQL certification preferred but not required. 

Designation SQL Database Administrator

LocationMohali, Chandigarh,

Job Description & Responsibilities

• Provide database monitoring and support of multiple 24/7 enterprise SQL Server always on availability groups.
• Troubleshoot issues as they occur, working with the Operations team during incidents, and resolving problems quickly and to a high standard.
• Maintain database performance by identifying and resolving production and application development problems, calculating optimum parameter values, evaluating
• new release code, answering developer questions and advising on code changes.
• Develop and configure database solutions, configuration of new systems, defining database structure, improving security, ensuring back-ups and restores meet audit requirements.
• Ensure all database systems meet RPO & RTO policies.
• Work with the Engineering Team to design and optimize SQL solutions.
• Work with the Operations Team to manage, install and configure servers in multiple data centres around the world.
• Update job knowledge by participating in educational opportunities, reading professional publications, maintaining personal networks, and participating in professional organizations.
• Ability to work closely with developers to resolve issues and improve systems.
• High level knowledge of Windows and Windows security and how they affect SQL Server.
• Knowledge of PowerShell scripting.
• Excellent analytical and problem-solving skills.
• Excellent written and verbal communication skills.

Education

• BE, B. Tech, M. Tech in Computer Science or equivalent.

Certifications

• Knowledge of Clustering.
• Knowledge of Database Migration.
• Knowledge of Database Mirroring.
• Knowledge of Log Shipping.
• Knowledge of Mirroring.
• Knowledge of Replication.
• Knowledge of SQL DBA.

Work Experience

• 05 to 08 years of experience as a SQL Database Administrator.
• Experience in Airlines or travel domain is a plus.

Skills

• Responsible for installation and configuration of SQL Server 2016/2017/2019.
• Scheduling jobs and job monitoring.
• Performing SQL Server upgrades, applying patches, and monitoring status.
• Manage user and role level security.
• Understanding and modifying existing stored procedures.
• Configured always On, log shipping and replication.
• Creating databases and logins with permissions in SQL Servers as developer's request.
• Implemented database standards and naming conventions for the database objects.
• Monitoring the databases as per the daily schedule tasks to check the health of databases using DBCC commands.
• Monitoring jobs like backup and restore check the error log for daily running batch jobs.
• Performance tuning high-level understanding.
• Troubleshooting issues high-level understanding.

Description :

Key Responsibilities :

Primary Database Expertise :

1. One resource should have PostgreSQL as their primary database expertise.

2. One resource should have MySQL as their primary database expertise.

3. One resource should have either PostgreSQL or MySQL as their primary database expertise.

Secondary Database Skills :

- Proficiency in other databases such as MongoDB, MSSQL, ElasticSearch, Oracle, and Redis is a plus.

- Hands-on experience with databases in cloud environments, including GCP, AWS, or Azure, is a must.

- Familiarity with database migrations on GCP, AWS, or Azure cloud platforms is advantageous.

Qualifications and Skills :

- Minimum of 4 years of hands-on experience with MySQL, PostgreSQL, and MSSQL databases.

- Strong logical thinking skills to analyze and solve complex database-related issues.

- Excellent communication and articulation abilities, with the capacity to interact effectively with both technical and non-technical stakeholders.

- Proficiency in handling customer calls and addressing their database-related queries and concerns.

- Experience in one of the following primary databases : PostgreSQL, MySQL.

- Knowledge of secondary databases like MongoDB, MSSQL, ElasticSearch, Oracle, and Redis is a plus.

- Prior experience with database administration in GCP, AWS, or Azure cloud environments.

- Familiarity with database migration processes on cloud platforms is a beneficial skill.

This role offers an opportunity to work with diverse database technologies and cloud platforms, making it an ideal position for a skilled Senior DBA who enjoys a dynamic and challenging environment. If you have a strong database background and are looking to take your career to the next level, we encourage you to apply.