PostGres SQL Database Administrator IV

Responsibilities: Participates in projects as assigned providing expertise related to Cloud Database Architecture (AWS or Azure). Analyzes database and information needs of projects and applications in order to recommend and implement cost-effective solutions. Conduct systems design, feasibility and cost studies and recommend cost-effective cloud native solutions. Develop standardized machine images and Cloud formation automation scripts for building non-prod and prod environments on AWS.Experience in managing, maintaining, patching, upgrading and ensuring operational continuity of both Postgres and Oracle Databases and associated components using the following products: PgPool Cluster, Postgres tools, Oracle Enterprise Manager, Data Guard, RMAN Must have good UNIX, Linux knowledge and scripting skills Schedules and coordinates database maintenance activities. Strong capability and ability to resolve highly technical and complex database and infrastructure related issues on their own before they impact production and the business. Provides technical expertise to the development of solutions for such items as DBMS tools and utilities usage, database administration, backup and recovery, database performance tuning and monitoring. Ability to influence development organizations to comply with database best practices and database standards and practices. Trouble-shoots database and/or software problems as they apply to design, implementation, or installation activities. Performs database migrations, upgrades and structure migrations. Participates in 7x24 on-call, overnight off-hour production problem resolution activities as needed in rotation. Develops and maintains DBMS related standards and procedures, knows where they are located, and makes full use of them. Follows software development processes. Performs other assignments to comply with the SR&T corporate purpose and mission to add business value, increase revenue, decrease costs, improve productivity, and support the strategic initiative/directive. Complies with all security and audit standards. Ensures security of company information by ensuring database is secure and monitors environment to identify improper access. Knowledge, Skills, and Abilities: Must have experience supporting Postgres and Oracle Databases. Must have experience with administration of Databases on AWS Cloud using RDS and/or EC2. PostgreSQL Database Administrator in versions 9.x and 12.x with Postgres Advanced Server using Enterprise Manager and SQL analyzer. Demonstrate recent, professional exposure to support alternate RDBMS database flavors like MS SQL SERVER, Aurora, & NoSQL. 7-10 years of experience, with at least the last 5-7 years as Lead DBA on all aspects of Postgres and Oracle Database Administration in a large/challenging database environment. Experience with automation tools (Ansible, Jenkins) & container technologies (Docker, CoreOS) is a big plus and desired. Experience supporting internet/web-based database applications with heavy concurrent user volume. Experience operating in traditional and agile project models. Strong Interpersonal skills to resolve problems in a professional manner, lead working groups, negotiate, and create consensus with both internal associates and external customers. Proficient at time and priority management. Postgres Replication and data encryption.

Education: The candidate should have a bachelor's degree or master's in Computer Science or 7 to 10 years of related experience in IT or a related field.