PostgreSQL DBA

Employer
VivSoft Technologies LLC
Location
Baltimore, MD
Posted
Jun 14, 2018
Closes
Jun 15, 2018
Industry
Specialty Trades
Hours
Full Time
Job Description We are seeking PostgreSQL Server database administrator for our client in Health Insurance Exchange domain. This is 5 Years contract. PostgreSQL DBA Duties/Responsibilities: · Perform PostgreSQL Server database administration, manage role based (RBAC) user accounts and system accounts, patch Management and maintain Replication/DR Environment. · Monitor all production database activity for operational improvements to include CPU, Disk and memory utilization, space utilization. · Monitor and manage PostgreSQL Enterprise Failover Manager (EFM). · Perform Security infractions and overall performance of databases to develop and implement corrective measures for database issues/problems found during monitoring. · Analyze performance issues in the application and database tiers. · Perform disaster recovery principles and practices, including planning, testing backup/restore. · Maintain Replication/DR Environment of Postgres Hands on maintenance activities such as vacuum, full vacuum, analyze the PostgreSQL Database. · Perform database server maintenance, including upgrades of PostgreSQL Database, storage management of PostgreSQL and MongoDB. · Perform Installation and maintenance of MongoDB database for high availability. · Tune SQL queries for optimal performance on PostgreSQL, create and manage indices. · Tune No SQL queries on Mongo DB and create/manage indices. Minimum Qualifications · A minimum of six (6)years of experience in PostgreSQL Server database administration, patch management and maintenance of Replication/DR Environment · A minimum of four (4)years of experience monitoring all production database activity for operational improvements to include CPU, Disk, memory utilization, space utilization, security infractions and overall performance of databases. · A minimum of four (4)years of hands on experience with maintenance activities of PostgreSQL Database such as Vacuum, FullVacuum, analysis in production and lower environments. · A minimumof four (4) years of experience maintaining Replication/DR Environment of Postgres including patches and upgrades of PostgreSQL Database. · A minimum of four (4) years of experience in Installation and maintenance of MongoDB for high availability; designing MongoDB multi-shaded cluster and monitoring with Ops Manager. · A minimum of six (6)years of experience in installation, configuration of MS SQL Server 2008, 2008 R2, 2014 and 2016 on Windows 2008 R2 and 2012 R2 servers, applying patches, service packs, hot fixes. · A minimum of five (5) years of experience with providing enterprise database solutions and data warehouse management. · A minimum of five (5) years of experience in analyzing database entities, optimizing SQL queries, designing database models for web applications. · A minimum of five (5) years of experience in analyzing and optimizing stored procedures and custom database functions. · A minimum of three (3) years of experience in installing and configuring highly available PostgreSQL and MongoDB clusters with enterprise security such as, PAM authentication, Kerberos authentication, encrypted storage mechanism. Preferred Qualifications · A minimum of four (4) years of experience in developing and implementing best practices for database issues/problems found during performance tuning of PostgreSQL DB and MongoDB. · A minimum of four (4) years of experience in disaster recovery principles and practices, including planning and validating backup and restore database backups in production and lower environments. · A minimum of four (4) years of experience implementing efficient disaster prevention and Recovery Strategies and High availability like Database Backup and Restore, Database Snapshot, Log shipping, Clustering and Database Mirroring for MongoDB/ MS SQL Server/ PostgreSQL. · A minimum of four (4) years of experience in designing MongoDB replica sets and sharded cluster, and upgrading and migrating various versions of Mongo database on different platforms. · A minimum of five (5) years of experience working with the PMO processes, policies and procedures. · A minimum of five (5) years of experience with Integrated Eligibility, Affordable Care Act or similar large Health and Human Service enterprise level Applications. · A minimum of four (4) years of experience as a database administrator developing and/or supporting federal or state based market places. · A minimum of three (3) years of experience in managing enterprise RDBMS and NoSQL databases on cloud platforms such as Amazon Web Services (AWS). Company Description VivSoft as an end to end solution provider specializing in Health IT and Cloud Systems Integration to various government organizations, including health agencies like Maryland's Department of Health and Mental Hygiene and Center for Medicare and Medicaid Services (CMS). VivSoft currently supports various agencies within State of Maryland and have a stellar track record providing IT Solutions. In addition, our other federal agency expertise includes NASA, Department of Veterans Affairs (VA) and Defense Contract Management Agency (DCMA).