Job Description :
Title Oracle DBA Position Type 1 contract position Length 12 months Responsibilities include: Primary DBA Functions: Configures and maintains Oracle Database, Microsoft SQL Server, PostgreSQL and MongoDB systems. Configures and supports cloud database systems DynamoDB, PostgreSQL RDS, Aurora and MongoDB. Performs Database maintenance (e.g., patching, upgrades, table/index reorganizations Document and perform database client installations / maintenance. Maintains database replication between servers. Analyzes existing database systems and recommend improvements. Supports the application development lifecycle. Creates and maintains database objects (e.g., tables, indexes, views, stored procedures, triggers Completes Request for Change tickets in a timely fashion. Works with Senior DBA staff on identifying and troubleshooting database issues (e.g., connectivity, performance, application errors, SQL errors Works with the Security team to enforce security policies. Demonstrates proficient use and knowledge of standards and procedures. When appropriate, works with applications areas regarding database design, performance, availability, SQL, and other related issues. DBA Maintenance Duties: Monitors storage and uptime for all databases (i.e., Annual Storage Report Supports routine maintenance of databases in maintenance windows. Maintenance includes table re-organization, chained-row repair and other maintenance assigned by Senior DBAs. Works with other Platform Services staff in planning and supporting maintenance windows. Maintains schedule for backend jobs and communicates changes or conflicts to operations and management. ETL Duties: Support the Extract Transform Load (ETL) processes used by the enterprise. Support includes: Mapping design and troubleshooting. Workflow runtime and troubleshooting. ETL connectivity support. ETL Administrative support (e.g., Manage Folders, Manage Security ETL Software Upgrades and Patches. Special Projects: Develops tasks needed to complete the projects. Reviews these plans with management. Completes documentation and cross training of DBA team on all new projects and procedures. Works with application development groups where appropriate in supporting these projects. Seeks input from the DBA staff when developing these projects. SECONDARY FUNCTIONS: Job functions that are not essential but are considered part of the job. Other duties may be assigned. Works effectively with people; makes efforts to listen to internal and external customers and understand their needs. Gives high priority to customer satisfaction. Maintains effectiveness in varying environments, tasks, responsibilities, or people. Demonstrates willingness to adapt to change and try new things. Utilizes MS Word, Excel, or MS Project to develop project plans. Skills and Abilities: Proficiency with Microsoft Office Tools. Linux knowledge. Experience with the following database technologies: 2+ years of experience as a Database Administrator focused on PostgreSQL (preferred) and/or Oracle 12c Experience managing and deploying Postgres in AWS using RDS Experience with performance tuning techniques for a heterogeneous database architecture (Redshift, PostgreSQL, Oracle) Experience managing temporary and permanent access to database objects Microsoft SQL Server MongoDB Understanding database architecture and how its components work and interact with one another. Ability to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Familiar with Git version control. Must be able to carry a pager and react to pages received on a rotation basis. Ability to create and troubleshoot SQL, PL/SQL, TSQL, Perl, python, bash code, and Terraform. Experience with database modeling and tools. Ability to work independently. Possess excellent troubleshooting skills. Possess excellent analytical skills. Ability to work on multiple projects simultaneously and in a fast-paced environment. Ability to meet deadlines. Demonstrates strong initiative to improve skill set. Demonstrates ability to apply skills learned at training to tasks assigned. Demonstrates flexibility. Displays teamwork and a positive attitude. Minimum Education and/or experience required: Bachelor's degree (B.A from four-year college or university, or related experience; and two years related database experience in a cloud environment. Preferred Experience: AWS experience
             

Similar Jobs you may be interested in ..