Job Title: Expert Database Developer
Job Summary:
We are seeking an Expert Database Developer to architect, develop, and optimize high-performance, large-scale database systems. The ideal candidate will have deep expertise in SQL, NoSQL, data modeling, cloud databases, performance tuning, and security. This role involves leading database architecture decisions, optimizing mission-critical systems, ensuring high availability, and mentoring teams in advanced database strategies.
Key Responsibilities:
- Design, architect, and optimize relational and NoSQL databases for scalability, performance, and reliability
- Develop complex SQL queries, stored procedures, triggers, and database functions for efficient data retrieval
- Optimize indexing, partitioning, sharding, and caching strategies for high-volume data processing
- Implement and oversee database security best practices (encryption, role-based access control, auditing, and compliance)
- Develop and manage data pipelines, ETL processes, and data warehousing solutions
- Architect and implement high-availability and disaster recovery strategies, including replication, clustering, and failover solutions
- Design and manage cloud-based database infrastructures (AWS RDS, Aurora, Google Cloud SQL, Azure SQL, Snowflake, BigQuery)
- Lead data governance, compliance, and regulatory adherence (GDPR, HIPAA, PCI-DSS)
- Collaborate with DevOps teams to integrate databases into CI/CD pipelines and automate database deployments
- Work with big data and distributed systems technologies (Hadoop, Spark, Kafka) for large-scale data processing
- Mentor junior and senior developers, conduct code reviews, and establish best practices in database development
- Research and integrate emerging database technologies, ensuring adoption of modern tools and methodologies
Skills and Knowledge Required:
- Expert proficiency in SQL, PL/SQL, and T-SQL
- Deep experience with relational databases: MySQL, PostgreSQL, Microsoft SQL Server, Oracle
- Advanced expertise in NoSQL databases: MongoDB, Redis, Cassandra, DynamoDB, Firebase
- High-level knowledge of cloud database solutions: AWS RDS, Aurora, Google Cloud SQL, Azure SQL, Snowflake, BigQuery
- Mastery of query optimization techniques, indexing strategies, execution plans, and performance tuning
- Strong expertise in data architecture, sharding, and distributed databases
- Proficiency in database security, encryption, authentication, and auditing
- Hands-on experience with ETL frameworks and data integration tools (Apache NiFi, Talend, Informatica, Airflow)
- Strong scripting skills for database automation (Python, Bash, PowerShell)
- Experience with big data technologies (Hadoop, Spark, Kafka) and real-time data processing
- Ability to automate database management using DevOps tools (Terraform, Ansible, Kubernetes)
- Familiarity with AI/ML-driven database optimizations (TensorFlow, MLFlow, predictive indexing)
Educational Qualifications:
- Bachelor’s, Master’s, or PhD in Computer Science, Data Science, Information Technology, or a related field
- Advanced certifications in SQL Server, Oracle DBA, AWS/Azure Cloud Databases, or Big Data Technologies are a plus
Experience:
- 8+ years of hands-on experience in database development, optimization, and architecture
- Proven experience in leading large-scale, high-performance database solutions
- Strong background in mentoring teams and setting enterprise-wide database strategies
Key Focus Areas:
- High-Performance & Scalable Database Architecture
- Cloud Database Solutions & Distributed Systems
- Security, Compliance & Regulatory Best Practices
- AI/ML & Big Data Integration in Database Management
- Leadership & Innovation in Database Development
Tools and Technologies:
- Database Systems: MySQL, PostgreSQL, Microsoft SQL Server, Oracle, MongoDB, Cassandra, DynamoDB
- Query Languages: SQL, PL/SQL, T-SQL
- ETL & Data Pipeline Tools: Apache NiFi, Talend, Informatica, Airflow
- Big Data Technologies: Hadoop, Spark, Kafka, Flink
- Cloud Databases: AWS RDS, Aurora, Google Cloud SQL, Azure SQL, Snowflake, BigQuery
- Automation & DevOps: Git, Terraform, Ansible, Kubernetes, Docker
- Database Monitoring & Optimization: SQL Profiler, SolarWinds, New Relic, Prometheus, Grafana
Other Requirements:
- Exceptional analytical and problem-solving skills
- Strong leadership and strategic decision-making abilities
- Passion for optimizing databases, handling massive datasets, and ensuring data security
- Excellent communication skills to collaborate with executive stakeholders and development teams