Database Administrator IV

MedImpact•San Diego, CA

21h•$110,982 - $199,769•Onsite

About The Position

The Database Administrator IV 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..

Requirements

BS/BA and 8+ years’ experience or equivalent combination of education and experience, and 4 years of SME in respective areas
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 lifecycles
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
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 as needed
Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists.
Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.
Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane and solid geometry and trigonometry.
Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations.
Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations.
Ability to write reports, business correspondence, and procedure manuals.

Nice To Haves

Oracle Certified Expert
Oracle Certified Professional
Oracle Certified Associate
Oracle Certified Master

Responsibilities

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