Senior Database Specialist

Responsibilities • Led end-to-end database migration projects from Oracle to PostgreSQL hosted on Azure Cloud, ensuring minimal downtime and data integrity • Managing SAP Db2 databases, including planning, administration, and maintenance of mission-critical systems • Converting Crystal Reports and database scripts from Oracle to PostgreSQL, maintaining logic consistency, constraints, and data integrity • Performing performance tuning of batch jobs, queries, and resource-intensive workloads across MySQL, MS SQL Server, Db2, and PostgreSQL environments • Designing and developing scalable, high-performance database solutions using PostgreSQL for diverse client use cases Requirements • Design, develop, and maintaining scalable database solutions across multiple platforms including Db2, SQL Server, Oracle, MySQL, PostgreSQL, AWS MongoDB, and YugabyteDB • Managing database installation, configuration, upgrades, and patching in both on-premises and cloud environments • Supported multi-environment setups (Dev, QA, UAT, Prod) with consistent configuration management • Managed backup and recovery strategies, ensuring data durability and business continuity for critical systems • Architected and implemented high availability solutions using replication, clustering, and failover mechanisms across PostgreSQL, Db2, and SQL Server • Delivered distributed database solutions using YugabyteDB for scalable, cloud-native client architectures • Monitor database health and proactively troubleshoot performance bottlenecks and system issues • Collaborate with development teams to design efficient data models and support application performance • ⁠Optimize database performance through query tuning, indexing strategies, and execution plan analysis • Designed logical and physical data models aligned with application and business requirements • Must have government project experience