Sr. Database Administrator

Position:

Location:

Job Type:

Working days:

Salary:

Key Responsibilities

Database Management and Administration

• Design, implement, and maintain data models, database schemas, and table structures.
• Manage and maintain PostgreSQL, MSSQL, MySQL, and Redis databases, ensuring high availability, security, and optimal performance.
• Perform routine database maintenance tasks, including backups, restoration, disaster recovery planning, and database monitoring.
• Plan and execute database upgrades, patches, and version migrations with minimal downtime.
• User access management
• Strong understanding of sharding keys, data distribution, and partitioning strategies.
• DDL Performance Optimization
• Analyze and understand query execution plans to identify and resolve performance bottlenecks.
• Optimize query performance through tuning, indexing, partitioning and resource utilization monitoring.
• Implement database monitoring and alerting solutions to proactively address potential issues. Security and Compliance
• Implement security measures, such as user access controls, data encryption, and vulnerability assessments.
• Perform regular audits and ensure databases comply with industry standards and best practices.

Integration and Collaboration

• Collaborate with developers to design and implement database schemas, indexes, partitions and stored procedures.
• Work with data engineers and scientists to ensure smooth data ingestion and transformation processes.
• Monitor and optimize data transfer and synchronization processes to ensure seamless integration.

Disaster Recovery

• Apply knowledge of disaster recovery principles and practices, including planning, testing, and execution of backup/restore operations in AWS environment.
• Troubleshoot and resolve database-related issues, including performance problems, replication failures, and data inconsistencies.

Continuous Improvement

• Stay updated with the latest database technologies, trends, and best practices.
• Suggest and implement improvements to database systems and processes to enhance performance, scalability, and reliability.

Required Skills and Qualifications

• 7+ years of experience as a Database Administrator or in a similar role.
• Proficiency in managing Oracle, PostgreSQL, MongoDB, MySQL, and Redis databases.
• Strong understanding of query execution plans, query tuning, and performance optimization.
• In-depth knowledge of disaster recovery principles, including backup/restore operations.
• Familiarity with change request processes and 24x7 support for production environments.
• Experience implementing database security measures and conducting vulnerability assessments.
• Proficiency in troubleshooting and resolving complex database issues.
• Strong analytical, problem-solving, and communication skills.
• Knowledge of scripting languages like Python, Bash, or PowerShell for automation.

Preferred Qualifications

• Experience with cloud-based database solutions such as AWS RDS or standalone databases or cluster running in EC2.
• Knowledge of scripting languages like Python, Bash, or PowerShell for automation.
• Any Database certifications.
• Familiarity with CI/CD pipelines and DevOps practices.