Database Administrator

Prabhav Services Inc

Dallas, United States

about 2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

dice.com

Tech stack

Amazon Web Services Cloud Database Cluster Analysis Databases Continuous Integration Data Integrity Extract Transform Load (ETL) Data Mapping Data Mining Query Languages Shard (Database Architecture) Linux

+23 more

DevOps Python (Programming Language) PostgreSQL Microsoft SQL Server SQL Azure Windows Servers MongoDB Ansible Shell Script SQL Databases SQL Server Integration Services Transact-SQL Database Optimization Apache Spark Database Performance Event Driven Architecture Database Migration Amazon Relational Database Service Debezium Information Technology Apache Kafka Terraform Data Pipelines

Job description

The Database Administrator will be responsible for leading end-to-end migrations between SQL Server, PostgreSQL, and MongoDB environments to AWS Cloud. This role involves performing schema conversion, data mapping, ETL processes, and optimizing database performance. The Database Administrator will work closely with application teams to ensure successful migration and provide ongoing support., * Lead database migrations between SQL Server, PostgreSQL, and MongoDB environments

Perform schema conversion, datatype mapping, and index strategy redesign
Execute data extraction, transformation, and loading using ETL tools
Validate data integrity and optimize database performance
Install, configure, and manage MongoDB, SQL Server, and PostgreSQL instances
Monitor system health and troubleshoot performance issues
Collaborate with application teams on migration impact and rollback strategies
Produce detailed runbooks, migration plans, and post-migration reports
Support UAT, cutover rehearsals, and production go-live events

Requirements

<>Technical Skills

Strong hands-on experience with MongoDB 4.x/5.x, SQL Server 2016+, and PostgreSQL 12+
Expertise in SQL, PL/pgSQL, T-SQL, and MongoDB query language
Deep understanding of replication, clustering, sharding, and HA/DR strategies
Experience with Linux, Windows Server, and cloud database services (AWS RDS, Azure SQL, MongoDB Atlas)
Proficiency with migration tools such as pgloader, Ora2Pg, AWS DMS, SSIS, custom Python/Shell scripts

<>Soft Skills

Strong analytical and problem-solving capability
Clear communication and documentation discipline
Ability to lead cross-functional technical discussions and migration workshops, * Certifications: MongoDB DBA, Microsoft SQL Server, PostgreSQL Professional, or cloud database certifications
Experience with CI/CD, DevOps, Terraform, Ansible, or containerized database deployments
Exposure to event-driven architectures and data pipelines (Kafka, Spark, Debezium)
Bachelor’’s Degree in Computer Science or its equivalent in a related field