Senior DBA Oracle MS T-SQL

 

I.  PURPOSE OF POSITION: 

 

  The Senior Database Administrator supports the efforts of the IT Applications Development Group for the development and operation of applications utilizing database technology.  This person oversees application and system software changes to ensure full exploitation of database software capabilities and monitors/enhances database system performance to ensure a high level of system functionality and reliability.  The Database Administrator supports data accessibility across various computer platforms.  The Senior Database Administrator leads and manages the successful design, development and implementation of database, architecture, data integration and other IT implementation projects.

 

 

II.     ACCOUNTABILITIES /JOB FUNCTION:

 

1.  Applications Development Support - Supports the systems development process by providing logical database design services, managing the transformation of the logical design to the physical database, and participating in major application design reviews.  The Senior Database Administrator consults with developers on the design of applications having complex database considerations, designs custom database objects as required, and recommends data access solutions that best fit the needs of the application.  The Senior Database Administrator works in conjunction with the developer and other Systems DBA(s) to resolve database problems during application testing and implementation.

 

2.  Database Development – The Senior Database Administrator will use his expertise in Database Procedural Languages (Oracle PL/SQL, MS T-SQL) to develop Stored Procedures, Packages, Functions and Triggers as required to encapsulate and localize/centralize business rules and process logic in the database for more efficient code execution.

 

3.  Database Standards Creation and Enforcement - The Senior Database Administrator is responsible for creating and maintaining the corporate data dictionary. The Administrator is responsible for creating and maintaining Entity Relationship Diagrams as well as utilizing in-line, entity-level and column-level commenting. The Administrator is responsible for defining and enforcing naming standards and data type standards across the Enterprise.

 

4.  Production Support - Participates in the resolution of production problems that involve database issues.  Oversees the migration of database components between the test and production environments.  Ensures the continued cost effective performance of the database management system and related applications.  Provides ongoing support to other Operations and Support components as needed.

 

5.  Database System Support - Monitors database system performance in both Development and Production environments.  Researches and implements enhancements to improve system performance.  Maintains system tables providing access to database system components.  Works with other Technical Services staff for database software installation and maintenance.

 

6.  Environment Development - Participates in defining, implementing, and enhancing an application development and operating environment that fosters productivity and application quality.  Develops, documents, and monitors compliance with guidelines and standards for the use of database technology.  Conducts programming walk-through sessions to ensure compliance with database standards.

 

7.  Data Access Support - Works with the users to evaluate requirements to access data across various computing platforms.  Installs and supports various tools used to establish communication and data access between the platforms.

 

8.  Architecture Support – Provides input in analyzing, designing and “architecting” solutions to meet internal and external process requirements from a database and application integration perspective.  This will include detailed process flow diagrams, specifications and data mapping documentation in support of this requirement.

 

9.  Planning and Administration - Provides input in setting department goals and budgets as requested.  Participates and is accountable for the development of project plans and the administration of these projects.  Provides status reports.  Attends required meetings.

 

10.  Training - Develops Database training documentation consisting of logical/physical database design concepts, Structured Query Language (SQL) and database optimization techniques.  Provides on-going Database instruction to the Applications Development staff, as required.

 

11.  Database Environment - Ability to administer the following required: Oracle and SQL Server. Optionally: MySQL, Oracle RAC experience a plus. Extensive Stored Procedure, Package and Trigger experience is required.  Requires Logical and Physical Data Model and Design experience. Familiarity with the Erwin or ER/Studio data-modeling tool is a plus.  Experience with Client/Server or Internet development environment comprising of Visual Basic, Java and Oracle is optimal.

12.  Database Replication/Data Transformation - Responsible for the analysis and architecture associated with data replication between multiple SQL Server or Oracle database servers.  Experience with developing, configuration and implementation of Data Transformation Service (DTS) packages between database servers and environments. ETL experience to some degree is required.

 

13.  Operating System Environment - Requires knowledge of Unix/Linux, and exposure to Microsoft Windows Server, from an operating system, networking and administration perspective.

 

14.  Database Backup/Recovery - Develops, implements and maintains stringent backup/recovery processes for the development and production database environments.  Works closely with customers and Applications Development Staff to ensure proper database recovery and backup strategies are developed, implemented and tested.  Continually monitors and improves backup/recovery mechanisms as needed.

 

15.  Project Management/Leadership – Although there is a project management team in place, there are times when the DBA must plan and lead projects centered around database, and database systems.

 

III. JOB REQUIREMENTS:

 

1.  Required Educational Background and/or Specialized/Technical Knowledge

 

·  Bachelors Degree in Computer Science, related field or equivalent experience.

·  Oracle Database Management Systems and Microsoft SQL Server Database Management Systems formal training a plus

 

2.  Required Work Experience (List position, function, type of business and length of

  time.)

 

·  Minimum of 5 years Database Management System experience in the Client/Server and Internet/Intranet paradigm.

·  Expertise with the administration, management, support and development utilizing Oracle Database Management System technology.

·  Experience with Internet/Intranet Technologies (e.g. HTML, CGI, Perl, Java) is a plus.

·  Experience with Logical and Physical Data Modeling and Design is required.

 

  3.  Required Supervisory/Interactive Skills

 

·  Must be a good people person and able to work with all levels of management.  Must be able to communicate clearly from both a written and oral perspective.