Job Title: Senior Database Developer
Job Summary:
We are looking for a Senior Database Developer to design, implement, and optimize scalable, high-performance database solutions. The ideal candidate should have deep expertise in SQL, database architecture, performance tuning, and cloud-based database solutions. This role involves leading database development projects, mentoring junior developers, ensuring data security, and optimizing large-scale databases for mission-critical applications.
Key Responsibilities:
- Architect, develop, and maintain high-performance, scalable relational and NoSQL databases
- Design and optimize complex SQL queries, stored procedures, views, and triggers
- Implement database indexing, partitioning, and query execution optimizations to improve performance
- Lead database design and modeling efforts, ensuring efficient data structures and relationships
- Develop and manage ETL (Extract, Transform, Load) processes for large-scale data processing
- Ensure database security and compliance with standards such as GDPR, HIPAA, and PCI-DSS
- Implement disaster recovery, backup strategies, and replication mechanisms
- Work with cloud-based database solutions (AWS RDS, Google Cloud SQL, Azure SQL, Snowflake, BigQuery)
- Develop data warehouses and OLAP solutions for analytics and business intelligence
- Monitor and troubleshoot database performance, deadlocks, and query execution plans
- Automate database maintenance tasks using scripting (Python, Shell, PowerShell, Bash)
- Collaborate with software engineers, DevOps, and data analysts to ensure seamless application integration
- Mentor junior and mid-level database developers, conduct code reviews, and enforce best practices
Skills and Knowledge Required:
- Expert proficiency in SQL, PL/SQL, and T-SQL
- Strong expertise in relational databases: MySQL, PostgreSQL, Microsoft SQL Server, Oracle
- Experience with NoSQL databases: MongoDB, Redis, Cassandra, DynamoDB (optional)
- Deep understanding of performance tuning, indexing strategies, query execution plans, and database caching
- Experience in designing high-availability and fault-tolerant database systems
- Proficiency in ETL, data migration, and data warehousing solutions
- Knowledge of database security best practices: encryption, role-based access control, auditing
- Hands-on experience with cloud-based database management (AWS RDS, Aurora, Google Cloud SQL, Azure SQL)
- Experience with DevOps tools for database automation (CI/CD pipelines, Terraform, Ansible, Kubernetes)
- Proficiency in database monitoring tools: SQL Profiler, SolarWinds, New Relic, Prometheus
- Familiarity with big data technologies: Hadoop, Spark, Kafka (a plus)
- Ability to script and automate database tasks using Python, Shell, or PowerShell
Educational Qualifications:
- Bachelor’s or Master’s degree in Computer Science, Information Technology, Data Science, or a related field
- Certifications in SQL Server, Oracle Database, AWS/Azure Cloud Databases, or Big Data Technologies are a plus
Experience:
- 5-8+ years of experience in database development, administration, and performance tuning
- Proven experience in handling large-scale databases, high-transaction environments, and mission-critical systems
Key Focus Areas:
- Advanced Query Optimization & Performance Tuning
- High-Availability & Scalable Database Architectures
- Cloud Database Solutions & Disaster Recovery Strategies
- Data Security, Compliance, and Governance
- Leadership & Mentorship in Database Development
Tools and Technologies:
- Database Systems: MySQL, PostgreSQL, Microsoft SQL Server, Oracle, MongoDB, Cassandra
- Query Languages: SQL, PL/SQL, T-SQL
- ETL & Data Pipeline Tools: Apache NiFi, Talend, Informatica, Airflow
- Cloud Databases: AWS RDS, Google Cloud SQL, Azure SQL, Snowflake, BigQuery, DynamoDB
- Version Control & Automation: Git, GitHub, GitLab, Terraform, Ansible
- Database Monitoring Tools: SQL Profiler, SolarWinds, New Relic, Prometheus, Grafana
Other Requirements:
- Strong leadership, analytical thinking, and problem-solving skills
- Ability to mentor and guide database developers
- Strong communication skills to collaborate with cross-functional teams and stakeholders
- Passion for scalable, secure, and high-performance database solutions