Job Title: Senior Database Administrator (DBA)
Job Summary:
We are seeking a Senior Database Administrator (DBA) to design, manage, and optimize enterprise-level databases for high-performance applications. The ideal candidate should have deep expertise in relational and cloud-based database administration, query optimization, security, high availability, and disaster recovery planning. This role involves leading database strategy, mentoring junior DBAs, collaborating with cross-functional teams, and ensuring data security and regulatory compliance.
Key Responsibilities:
- Architect, install, configure, and manage relational database management systems (RDBMS) including MySQL, PostgreSQL, Microsoft SQL Server, and Oracle
- Optimize database performance by tuning queries, implementing indexing strategies, and monitoring execution plans
- Ensure database high availability (HA), clustering, replication, and failover strategies for business continuity
- Develop and enforce security best practices, including encryption, authentication, role-based access control (RBAC), and compliance with GDPR, HIPAA, PCI-DSS
- Manage backup and disaster recovery strategies, ensuring rapid recovery from failures
- Collaborate with DevOps, software development, and business teams to optimize database performance for applications
- Lead cloud database migrations and hybrid database deployments (AWS RDS, Google Cloud SQL, Azure SQL, Snowflake)
- Automate routine database tasks using scripting (Python, Bash, PowerShell) and infrastructure as code (Terraform, Ansible)
- Monitor and troubleshoot performance bottlenecks, deadlocks, query inefficiencies, and database downtime
- Manage large-scale data migration, ETL processes, and data integration strategies
- Mentor and lead junior DBAs, enforcing best practices and driving innovation in database technologies
- Document database architectures, security policies, and operational procedures
- Stay ahead of emerging database technologies, cloud advancements, and big data trends
Skills and Knowledge Required:
- Expert-level SQL proficiency (SQL, PL/SQL, T-SQL) and query optimization expertise
- Extensive experience managing and optimizing relational databases (MySQL, PostgreSQL, SQL Server, Oracle)
- Proficiency in cloud-based database platforms (AWS RDS, Google Cloud SQL, Azure SQL, Snowflake)
- Deep knowledge of database replication, clustering, sharding, and high-availability architectures
- Strong expertise in security management (data encryption, authentication, access controls, and compliance)
- Hands-on experience with database monitoring and performance tuning tools (SQL Profiler, SolarWinds, New Relic, Prometheus, Grafana)
- Experience with DevOps and automation tools (Terraform, Ansible, Kubernetes, Docker, Jenkins)
- Strong scripting skills (Python, Bash, PowerShell) for database automation
- Understanding of big data technologies (Hadoop, Spark, Kafka, Flink) (optional)
- Experience in managing data governance, metadata management, and compliance regulations
Educational Qualifications:
- Bachelor’s or Master’s degree in Computer Science, Information Technology, Data Science, or a related field
- Certifications in SQL Server, Oracle DBA, AWS/Azure Cloud Databases, or Database Security are preferred
Experience:
- 5-8+ years of experience in database administration, performance tuning, and security management
- Proven track record of leading database teams, handling mission-critical data, and driving cloud migrations
Key Focus Areas:
- Database Performance Tuning & Query Optimization
- Cloud & Hybrid Database Management
- High Availability, Clustering & Disaster Recovery
- Security & Regulatory Compliance in Database Management
- Leadership & Mentorship in DBA Teams
Tools and Technologies:
- Database Systems: MySQL, PostgreSQL, Microsoft SQL Server, Oracle
- Query Languages: SQL, PL/SQL, T-SQL
- ETL & Data Integration: Apache NiFi, Talend, Informatica, SSIS
- Cloud Databases: AWS RDS, Google Cloud SQL, Azure SQL, Snowflake
- Monitoring & Optimization: SQL Profiler, SolarWinds, New Relic, Prometheus, Grafana
- Version Control & Automation: Git, Terraform, Ansible, Kubernetes, Docker
Other Requirements:
- Strong leadership and decision-making skills for managing critical database systems
- Ability to collaborate across teams and influence database strategies
- Excellent documentation and communication skills to convey complex database solutions to stakeholders
- Passion for database security, high performance, and continuous optimization