Performs all Database Administration related activities for major CLIENT projects independently with minimal supervision.
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.
Design complex solutions which integrate AWS cloud, on premise physical and Virtual server, EC2, S3 storage, networking and security. Conduct systems design, feasibility and cost studies and recommend cost-effective cloud solutions.
Develop standardized AMI 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 the Oracle Database and associated components using the following Oracle products:
Oracle Enterprise Manager
Oracle Data Guard.
Oracle Recovery Manager
Oracle RAC implementation
Oracle Automatic Storage Management (ASM)
Oracle Golden Gate
Good UNIX, Linux knowledge and scripting is a must.
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 CLIENT 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.
Trouble-shoots database and/or software problems as they apply to design, implementation, or installation activities.
Participates in on-call, overnight off-hour production problem resolution activities.
Develops and maintains DBMS related standards and procedures, knows where they are located, and makes full use of them. Follows CLIENT 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 CLIENT 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:
Experience with administration of Databases on AWS Cloud using RDS and/or EC2 is a MUST.
Demonstrate recent, professional exposure to support alternate RDBMS database flavors like MS SQLSERVER, Postgres, Aurora, & NoSQL will be preferred.
10-12 years of experience, with at least the last 5-7 years as Lead Oracle DBA on all aspects of Oracle Database Administration in a large/challenging database environment.
Experience with automation tools (Ansible, Jenkins) & container technologies (Docker, CoreOS) is a plus.
Experience supporting internet/web based database applications with heavy concurrent user volume.
Experience working on RAC database applications, OEM, RMAN, Data guard & Golden Gate.
Experience operating in traditional and agile project models
Willingness to work on-call DBA rotations in a 7x24 environment
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.
Phone: 732-490-6615 X 296