Overview
On Site
Full Time
Skills
Performance Management
Recovery
Modeling
Writing
Stored Procedures
Software Development
Backup
SOP
IT Security Audit
Reporting
IT Management
Archiving
Data Analysis
Documentation
Disaster Recovery
Failover
IT Security
Information Technology
Mentorship
SLA
Supervision
Health Care
Microsoft Azure
Cloud Computing
Database Administration
Real-time
Version Control
Git
Management
GitHub
Bitbucket
Data Migration
Testing
Development Testing
Extract
Transform
Load
Data Conversion
Oracle
PostgreSQL
Data Modeling
Linux
NoSQL
Cosmos-Db
Redis
Database
Technical Direction
Analytical Skill
Migration
Stacks Blockchain
Stakeholder Management
Change Management
Communication
Presentations
Attention To Detail
ADA
SAP BASIS
Law
IT Service Management
Innovation
Collaboration
Recruiting
Insurance
Finance
Professional Development
Training
Leadership
CompTIA
Customer Service
Career Counseling
Apex
Oracle Application Express
Job Details
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:
Supervisory Responsibilities
This job has no supervisory responsibilities.
Education and/or Experience
For consideration candidates will need:
Computer Skills
Certificates, Licenses, Registrations
None required, but any DB certifications is a plus.
Other Skills and Abilities
Travel
This position may require domestic travel as well as attendance at various local conferences and meetings.
The Perks:
?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.
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.