What are the responsibilities and job description for the Lead Database Engineer (Database management & optimization, Sql and Nosql) - Hybrid position at DataFactZ?
Job Details
Job Role: Lead Database Engineer (SQL and NoSQL)
Location: Lake Mary, FL(3 days onsite is must)
Hire-Type: Contract
Data Engineer background in database management and optimization. Demonstrated expertise in ensuring high availability, performance, and scalability of critical systems. Proficient in both SQL and NoSQL databases, including MySQL, PostgreSQL, MongoDB, Redis, and Cassandra. Skilled in advanced query tuning, indexing strategies, and performance tools like pgAdmin.
Strong capabilities in automation, monitoring, and incident response, utilizing tools such as Prometheus, Grafana, ELK Stack, and CI/CD pipelines. Adept at managing cloud platforms (AWS, Azure, Google Cloud) and cloud-based database services (Amazon RDS, Azure SQL Database). Experienced in containerization and orchestration with Docker and Kubernetes, including stateful applications.
Committed to database security best practices, encryption, and compliance standards. Passionate about leveraging cutting-edge technologies to drive continuous improvement and operational excellence.
Skills:
- Database Management: MySQL, PostgreSQL, MongoDB, Redis, Cassandra
- Performance Optimization: Query tuning, indexing, caching, Percona Toolkit, pgAdmin
- High Availability: Replication, clustering, failover strategies
- Monitoring and Alerting: Prometheus, Grafana, ELK Stack
- Automation: Advanced scripting (Python, Bash, Ruby, Go), CI/CD pipelines
- Incident Response: Root cause analysis, post-mortem reviews
- Cloud Platforms: AWS, Azure, Google Cloud, Amazon RDS, Azure SQL Database
- Configuration Management: Ansible, Terraform, Kubernetes, Docker
- Data Warehousing: Amazon Redshift, Google BigQuery, Snowflake
- Security: Database security best practices, encryption, compliance standards
