The Senior Database Administrator is responsible for the definition, creation, and maintenance of the enterprise data model within the distributed computing environments (e.g., Unix, Windows, Intranet, Web). Analyzes, tests and implements physical database design supporting various business applications including base definition, structure, documentation, long-range requirements and operational guidelines. Ensures data recovery, maintenance, data integrity, and space requirements for physical databases are met through formulations and monitoring of policies, procedures, and standards related to database management. Above all, ensures solutions meet business objectives and establishes and maintains a high level of user trust and confidence in ITs knowledge of and concern for users business needs. Willingness to work with customers of varying levels of technical expertise in a high-pressure, complex environment. Performs job duties consistent within safety, legal and regulatory requirements; company standards, culture and business practices.
Essential Duties and Responsibilities:
Resolve problems and answer questions related to the RDBMS and its associative platform environment interdependencies (Unix, Windows); contact vendor support when necessary.
RDBMS performance monitoring and tuning; closely monitor performance; identify problems and implement solutions; ensure the database is running at optimum speed efficiency.
Maintain database backup and recovery environment; Respond quickly to refresh data; verify implementation of correct backup strategy; develop recover procedures; support recovery from loss of data caused by user or system error.
Install and upgrade RDBMS and related products; Keep RDBMS at current release and maintenance levels; install supporting products; provide current, stable production and development environments.
Reorganize database structures as needed: Automate procedures at regular intervals; use tools to reorganize or defrag database table spaces, tables, and indexes; provide application development staff optimal development environment with current data.
Provide assistance in database design as needed: Research and recommend optimal design criteria; publish standards and work with development staff; standardize environment and improve efficiency.
Capacity planning and reporting: Monitor file system space, database allocation, etc.; verify efficient use of disk storage in a SAN environment; reclaim dead space; optimize space allocation and avoid out-of-space conditions.
Produce: database normalization schemas, logical to physical database mapping, and data table parameters.
Develop rules, procedures, and standards for the access and maintenance of shared data resources.
Review overall physical database structures for data integrity, performance quality, recoverability, maintenance, and space requirement considerations.
Participate in the evaluation and recommendation of DBA tools and new DBMS technologies.
Perform change management, impact analyses, research products, configure software, and establish standards and procedures that support the Companys database environment needs.
Application-oriented database administration and technical support for the various development, training, testing, and production requirements of relational database environments.
Assist in the definition and development of database documentation and standards.
Conduct application transaction volume and traffic analysis, and interpret impact on database and network performance.
Provide mentoring and assistance to intermediate and junior DBA team members.
Contributes to departmental activities and programs by accomplishing related tasks as needed.
Knowledge, Skills and Abilities:
Strong working knowledge of state-of-the-art database concepts, design and deployment, recovery techniques, performance monitoring and tuning, Structured Query Language, and relational database design techniques.
Experience in designing, modeling, developing and supporting large RDBMS's.
Extensive experience in logical and physical database design, hands-on data modeling techniques, and development methodology; physical schema design of table spaces, rollback segments, and data files.
Experience in the designing of data extract, migration, and queuing facilities.
Proficiency in the concepts and practice of database normalization techniques.
Knowledge of server-side development issues surrounding triggers, stored procedures, and packages.
Solid project management skills, effectively managing multiple small to medium projects in a cross-functional environment.
Proficiency in several RDBMS-specific middleware tools and utilities to support such activities as monitoring, database migration, data transfer interfaces, and replication.
Thorough understanding of the relational database model and solid theoretical knowledge of relational database techniques; ability to see the big picture and conceptualize and document creative solutions.
Experience with cross-platform networking in a TCP/IP environment.
Experience with Unix shell scripting languages.
Full knowledge of SQL, including programming and ability to optimize SQL code.
Experience in one or more of the following tools: Oracle Enterprise Manager, TOAD, DBArtisan.
Some programming knowledge of more than one: C/C++, Perl, Unix shell, PL/SQL, T-SQL, Visual Basic).
Ability to write clear technical documents.
In order to accomplish the essential duties of this position, the incumbent must have:
Bachelors degree in Computer Science, Engineering or related discipline; equivalent experience acceptable.
At least 5 years of in-depth experience in the design, administration, programming, and support of RDBMS's (Oracle and SQL Server) in one or more computing environments: Unix, Windows
5 to 8 years of experience as a DBA in one or more environments is highly desirable (preferably with RDBMS's) or strong, demonstrated DBA skills earned in equivalent experience.