Our client, a US Fortune 50 organization and a leading provider of Health care and Health Insurance services, seeks an accomplished PostgreSQL DBA.
______________________________________________________________________
NOTE: THIS IS 100% REMOTE ROLE & ONLY W2 CANDIDATES (NO C2C/1099).
** Candidate must be authorized to work in USA without requiring sponsorship ***
Position: PostgreSQL DBA (Job ID: WLPTJP00047086)
Location: Baltimore MD (100% REMOTE)
Duration: 12 Months + Strong Possibility of Extension
____________________________________________________________________________
- Responsible for developing detailed logical data designs and metadata content. Works on more complex database design, development and support activities. Primary duties may include but are not limited to: Creates and populates metadata and plans and participates in unit testing for data validation.
- Evaluates test results for fulfillment of all data requirements. Develop conceptual or general designs, including logical design of databases, access methods, metadata presentation, etc. Details of all aspects of functional designs, including record layouts, pseudo-code, detailed data mapping, etc. Productionalizes data-related project components and institute all required changes.
- Provides ongoing support of business, including ongoing data analysis, data quality testing, enhancement of metadata, etc.
- Reviews SQL code and provides turning suggestions. Provides DBMS technical configuration and troubleshooting. Provides user management and DBMS security support. 24x7 production and non-production DBA on-call support.
Database Administrator:
Seeking a Senior Database Administrator/Data Modeler with expertise in PostgreSQL, Athena, and Redshift on Linux and Windows platforms. The role includes data modeling and the administration of production, test, and development databases. This position is part of a collaborative, agile team supporting modern, standards based web applications for mission critical health IT solutions.
Roles and Responsibilities:
- Maintain production, test, and development databases in the cloud
- Provide strong cloud based database administration and support
- Support database design, development, user administration, and deployment activities
- Perform database administration and engineering tasks to ensure optimal performance of PostgreSQL, Athena, Redshift, and related environments
- Install, configure, maintain, and ensure integrity of PostgreSQL, Athena, and Redshift clusters
- Incorporate long term operational and administrative requirements into database planning
- Design, implement, and maintain databases; manage backups, recovery, and configuration
- Optimize database configurations for performance, backup, and recovery; assist with SQL review and tuning
- Support high severity and production issues during weekends/off hours as needed
- Create logical and physical data models using approved tools and established standards
- Train team members in SQL and related tools
- Implement proactive monitoring of cloud database usage and support cost optimization
Required Qualifications:
- Requires an BA/BS degree in Information Technology, Computer Science or related field of study and a minimum of 3 years of information systems experience; or any combination of education and experience, which would provide an equivalent background. Experience in utilizing DBMS system management tools and the ability to implement new DBMS features and functionality strongly preferred.
- Experience with AWS RDS PostgreSQL, Athena, and Redshift
- Experience working on complex, high volume mission critical systems
- Hands on administration, performance tuning, and production support of PostgreSQL, Athena, Redshift, and other RDBMS platforms in high volume, customer facing environments
- Experience in Agile/Scrum environments
- Strong written, verbal, and interpersonal communication skills
- Ability to work in a dynamic team environment and manage priorities
- Ability to identify potential issues and escalate critical items promptly
- Strong attention to detail and commitment to task completion
Preferred Experience:
- Bachelor’s degree with at least 8 years of experience developing systems and applications for Federal clients.
- 7+ years of data modeling and database administration experience
- 4+ years with AWS RDS PostgreSQL on Linux/Unix
- 6+ years administering relational databases in the cloud
- 4+ years consulting with senior business SMEs to gather requirements
- 4+ years data modeling with ERWin or similar tools
- AWS certification and SAFe experience
- SQL development experience in Java
- SQL development experience in Python
- Dimensional modeling
- SQL Server experience
- Experience working on multi-disciplinary development teams
______________________________________________________
If you're looking for rewarding employment and a company that puts its employees first, we'd like to work with you. We're driven, people driven
Bhupesh Khurana
Senior Technical Recruiter
Email:
Amerit Consulting is an extremely fast-growing staffing and consulting firm. Amerit Consulting was founded in 2002 to provide consulting, temporary staffing, direct hire, and payrolling services to Fortune 500 companies nationally; as well as small to mid-sized organizations on a local & regional level. Currently, Amerit has over 2,000 employees in 47 states. We develop and implement solutions that help our clients operate more efficiently, deliver greater customer satisfaction, and see a positive impact on their bottom line. We create value by bringing together the right people to achieve results. Our clients and employees say they choose to work with Amerit because of how we work with them - with service that exceeds their expectations and a personal commitment to their success. Our deep expertise in human capital management has fueled our expansion into direct hire placements, temporary staffing, contract placements, and additional staffing and consulting services that propel our clients’ businesses forward.
Amerit Consulting provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.
Applicants, with criminal histories, are considered in a manner that is consistent with local, state and federal laws.
