Job Description  

The Senior Database Administrator (DBA) will work within a pool of other Senior DBAs to support  approximately 20 online transaction processing (OLTP) applications, online analytical processing (OLAP)  applications, and decision support systems (DSS). The database environment consists of databases that  range in size from several hundred gigabytes (GB) to several terabytesized databases. The database  management systems are both SQL Server and Oracle, so the successful applicant will have experience  with both environments. The Senior DBA pool will support these applications in both a localDBA and  centralDBA model. As the Local DBA, the candidate will directly provide all database services, including  programming, tuning, design, etc. As the Central DBA, the candidate will operate as guidance and  approval. As such, the candidate will need to be able to have excellent communication skills. 



Primary Responsibilities  

•  Analyze database requirements for OLTP and reporting and analysis applications.   Responsible for the architecture of technical solutions for the databaserelated portions of IT  projects.


•  Design and construct databases.  


•  Develop methods for integrating different products such as customizing commercial databases to fit  specific needs.  


•  Coordinate database development and determine project scope and limitations.  


•  Responsible for database provisioning and capacity planning for adequate database storage.  


•  Perform database backup and recovery using Oracle RMAN utility.  


•  Performing routine backups and restorations.  


•  Support Cloud Computation for Oracle/SQL Server databases.  


•  Perform data export and imports. Ensure integrity and recoverability of database structures.  


•  Responsible for database integrity of production databases.  


•  Develop operational procedures.  


•  Developing and implementing database administration policies & procedures including subsystem or  instance security guidelines.   Implement and maintain database structures and objects.  


•  Develop data model describing data elements and how they are used, following procedures and  using pen, template or computer software.


•  Prepare and update documents of database standards, user manuals, procedures and processes,  records, evaluations, schedule, project plans, reports, reviews, etc.  


•  Create and provide design artifacts for technical reviews of physical database models.  


•  Revise the company definition of data as defined in the data dictionary. Provide change  management and documentation for database changes.   Review periodic patches and new releases of Oracle software and implement the same in the CMS  environment. Install and maintain a Real Application Cluster (RAC).  


•  Approve, schedule, plan, and supervise the installation and testing of new products and  improvements to computer systems  


•  Install, configure, and maintain High Availability for Oracle databases.  


•  Migrate application data structures across multiple database platforms (such as SUN Solaris, IBM  zLinux, MS Windows, etc.) Participating in database migration reviews. Migrate databases to  different platforms, data centers, or AWS.  


•  Monitor and tune database environments for improved system performance.  


•  Provide query performance monitoring and tuning recommendations. Perform performance analysis  and enhancement of SQL queries.  


•  Establish and calculate optimum values for database parameters, using manuals and calculators.  


•  Select and enter codes to monitor database performance and to create a production database.  Responsible for the execution and monitoring of database utilities and scripts.  


•  Develop and test Oracle/SQL Server databases.  


•  Responsible for implementing or overseeing the implementation of all database programming.  


•  Develop and execute appropriate Data Definition Language (DDL) to support projects.  


•  Develop UNIX, Perl and other needed scripts to support applications and database administration  functions.  


•  Test programs or databases, correct errors and make necessary modifications.  


•  Write and code logical and physical database descriptions and specify identifiers of database to  management system or direct others in coding descriptions  


•  Provide guidance to database and application development personnel on the use and administration  of Oracle and SQL Server DBMS software.  


•  Lead and conduct technical reviews of physical database models.  


•  Review project requests describing database user needs to estimate time and cost required to  accomplish the project.  


•  Review procedures in database management system manuals for making changes to the database.  


•  Review and approve applicationbased scripts, utilities, stored procedures, functions, and triggers.  


•  Maintain quality of Oracle/SQL Server databases.   Responsible for the databaserelated production release of project solutions.  


•  Plan, coordinate and implement security measures to safeguard information in computer files  against accidental or unauthorized damage, modification or disclosure. Specify users and user access  levels for each segment of the database.  


•  Responsible for the security and integrity of the database environment.  


•  Maintain database control standards for central database administrators.


•  Review physical data models submitted in a CMSapproved format (currently: CA AllFusion) for  design integrity and adherence to published CMS database standards.  


•  Utilize management tools (e.g. Service Now) to support database users’ service requests. Provide  user support for data and databaserelated issues. Train users and answer questions.  


•  The scope of the services requires support during core and noncore hours. Core hours are 6 AM to 9  PM eastern time (ET). Noncore hours include the following categories of support: Emergency This  is offhours (noncore hours) support for database problems such as database crashes, backup  failures, slow performance etc.; and Scheduled (this includes upgrades and releases). Planned  support for work that cannot be conducted during core work hours. Oncall support during noncore  hours on a rotational basis. "    Required Qualifications  


•  A Bachelor's Degree from an accredited college or university with a major in Computer Science,  Information Systems, Engineering, Business, or other related scientific or technical discipline or a  commensurate combination of a relevant degree and 15 years total experience.  


•  Oracle certification is preferred.  


•  Experience working in the database domain with at least 10 years of experience managing all  operations of Oracle and SQL Server databases.  


•  Demonstrated skills in both Oracle and SQL Server    

Area of Expertise  Tools / DBMS Features:

Oracle 19c, Oracle 12cR2, Oracle Real Application Cluster (RAC) (1,2 Node),  Structured Query Language (SQL), Oracle PL/SQL, SQL*PLUS, PL/SQL, TSQL, Linux and Windows  Sysadmin skills, Shell Scripting (Bash/Korn/C shell), Oracle RMAN, Oracle SQL*Loader, Oracle DataPump,  Oracle +ASM, Symantec/Veritas NetBackup, OEM Cloud Control 13c, Oracle Automatic Workload  Repository (AWR), Oracle Automatic Database Diagnostic Monitor (ADDM), Oracle Active Session  History (ASH), OEM SQL Tuning Advisors, TOAD, Oracle SQL*Developer, Erwin Data Modeler, CA  AllFusion, MS SQL Server 2012/2016/2019, SQL Server Management Studio (SSMS), SQL Server  Integration Services (SSIS), SSIS Packages