PostgreSQL DBA

Job#: 2076715

Job Description:

Job Description

Postgres Database Administrator III

The Scoop:

The Postgres Database Administrator supports database administrative activities including but not limited to database patching, capacity, and performance management. This position also is responsible for backup and recovery configuration and execution, modeling and development support.

What You Get To Do:

• Demonstrated experience writing complex stored procedures and queries
• Proven experience troubleshooting and solving complex databases schemas/warehouses
• Understanding and experience of Software Development Life Cycle
• Experience in database development, administration, and management for PostgreSQL and Oracle
• Proven experience with integration from Oracle to Postgres and/or vice-versa
• Understanding of existing data models and ability to design new data models
• Administration and tuning of database, and data models for performance
• Ability to assess database for best practices and performance
• Ability to build security and backup strategies for database
• Ensuring database is performing at optimal levels
• Collaborating with engineering teams and clients on ensuring smooth operations of database
• Performs deployments in production and non-production environments
• Responsible for evaluating patching requests, communicating constraints, risks, impact, issues and timelines for deployment
• Collaborates with engineering teams and clients on ensuring optimal operations of database
• Streamlines cloning or similar activities to build/refresh non-production environments
• Supports and enforces change management SOP, including maintenance across multiple environments
• Supports IT security Audit Reporting
• Provides technical leadership and advice for the company's use of DB and related technologies
• Provide leadership and guidance on large, complex, and cross functional projects and tasks
• Provides database back-up, archiving, monitoring, data analysis and troubleshoots data issues
• Assists with related task planning, training and technical direction of other Applications Administrators, DBAs or IT software engineers and developers
• Develops documentation for the assessment and automation of repeatable processes
• Assists in maintaining plans for disaster recovery and failover capabilities and testing
• Maintains security according to company guidelines and works closely with the IT Security team to develop additional robust solutions
• Provides peer reviews for work produced by other Application DBA's and/or software engineers
• Trains other IT Application DBAs within the Information Technology department and acts as a mentor to less experienced staff
• Provides On-Call support after hours and on weekends (on a rotational basis) per the department's On-Call agreement to meet SLA's and metrics

Supervisory Responsibilities

This job has no supervisory responsibilities.

Education and/or Experience

For consideration candidates will need:

• Bachelor's degree (or equivalent combination of education and experience)
• Five (5) to eight (8+) years' related experience
• PBM or healthcare related industry experience a plus

Computer Skills

• PostgreSQL Database administration
• Experience in administering cloud-based multiuser environment with expertise in planning, designing, building, and implementing complex database systems (Azure cloud-based Postgres database administration experience or similar database administration experience)
• Experienced with optimizing database performance through testing and ongoing real-time monitoring
• Experience working with version control systems like GIT and used Source code management tools GitHub and Bitbucket
• Oracle Data Migration experience including validation/testing and reconciliation
• Create, tune, administer, and maintain Postgres DB instances for high volume, mission critical systems throughout the development, test, and production lifecycle
• Design and develop logical and physical database designs from customer application requirements
• Support daily administration, monitoring, tuning, and troubleshooting in PostgreSQL clusters on Linux
• Use Flyway to apply schema updates and track the deployment process through environments
• Participate in ETL and data conversion activities from Oracle to Postgres
• Hands on Data modeling/modeler
• Hands-on experience with Linux based databases preferred
• Hands-on experience with NOSQL databases like Cosmos DB, Redis preferred

Certificates, Licenses, Registrations

None required, but any DB certifications is a plus.

Other Skills and Abilities

• Ability to work independently, work as a member of and provide technical direction to a cohesive team with excellent interpersonal skills
• Strong analytical and communication skills
• Leading meetings and acting as a facilitator along with the ability to logically present and communicate ideas to work groups
• Ability to develop and execute focused infrastructure projects such as upgrades and migrations
• A solid understanding of enterprise technology stacks
• Ability to architect technology solutions and influence enterprise adoption through stakeholder management
• Incident and change management skills
• Good verbal, written communication and presentation skills
• Excellent organizational, attention to detail, and follow-up skills
• Must be available for on-call work after-hours and weekend work as needed

Travel

This position may require domestic travel as well as attendance at various local conferences and meetings.

The Perks:

• Medical / Dental / Vision / Wellness Programs
• Paid Time Off / Company Paid Holidays
• 401K with Company match
• Life and Disability Insurance
• Tuition Reimbursement
• Employee Referral Bonus

?Equal Opportunity Employer, Male/Female/Disabilities/Veterans

OSHA/ADA:

To perform this job successfully, the successful candidate must be able to perform each essential duty satisfactorily. The requirements listed are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Disclaimer:

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or .

Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.

Apex Benefits Overview: Apex offers a range of supplemental benefits, including medical, dental, vision, life, disability, and other insurance plans that offer an optional layer of financial protection. We offer an ESPP (employee stock purchase program) and a 401K program which allows you to contribute typically within 30 days of starting, with a company match after 12 months of tenure. Apex also offers a HSA (Health Savings Account on the HDHP plan), a SupportLinc Employee Assistance Program (EAP) with up to 8 free counseling sessions, a corporate discount savings program and other discounts. In terms of professional development, Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA. Apex has a dedicated customer service team for our Consultants that can address questions around benefits and other resources, as well as a certified Career Coach. You can access a full list of our benefits, programs, support teams and resources within our 'Welcome Packet' as well, which an Apex team member can provide.