Database Administrator

KNOWLEDGE, SKILLS & ABILITIES:

1. Knowledge of Oracle and MySQL data base management technologies in UNIX/LINUX operating system environment;
2. Knowledge of Microsoft SQL Server in a Windows operating system environment;
3. Knowledge of Oracle, Microsoft SQL Server and MySQL internals, data structures, and memory management;
4. Knowledge of Oracle network connectivity;
5. Knowledge of SQL and PL/SQL languages;
6. Knowledge of UNIX/LINUX operating system and commands;
7. Knowledge of Microsoft Server operating system and commands;
8. Knowledge of computer programming, systems analysis and systems design principles and practices;
9. Experience installing and maintaining Oracle, Microsoft SQL Server and MySQL software and databases;
10. Experience designing, developing, testing, documenting and implementing database backup and recovery procedures;
11. Experience performing database backup and recovery processes for Oracle using RMAN;
12. Experience performing database backup and recovery processes for Microsoft SQL Server;
13. Experience configuring data base parameters for performance tuning;
14. Experience developing, testing, documenting and implementing SQL, Oracle PL/SQL, UNIX/LINUX shell scripts and Windows operating system BAT orCMD shell scripts;
15. Ability to use critical thinking skills and problem solve;
16. Ability to work independently;
17. Ability to create logical, well-written standards and procedures related to database design and database administration;
18. Ability to write, code, test, debug, and review computer programs and stored procedures;
19. Ability to process information logically and solve problems;
20. Ability to identify and define user requirements;
21. Ability to communicate effectively verbally and in writing;
22. Ability to establish and maintain effective working relationships with others;

Preferred Experience:

1. 8 years of experience working with Oracle RDBMS software and databases (version 11g or more recent)
2. 8 years of experience developing SQL, PL/SQL scripts, procedures, functions and packages
3. 5 years of experience planning, developing and executing data conversion/migration plans, processes and programs
4. Experience facilitating analysis sessions with business clients
5. Experience presenting technical subject matter reviews or seminars to business clients
6. Experience designing and executing quality control and test procedures

Description of Services & Deliverables

Database Administrator responsibilities include but may not be limited to the following:

1. Management and administration of Oracle, Microsoft SQL Server and MySQL database software and databases;
2. Installing, configuring, patching and maintaining Oracle, Microsoft SQL Server and MySQL database software and databases;
3. Ensuring the availability, integrity and security of database data;
4. Providing database backup and recovery services;
5. Developing and maintaining utility programs, scripts and routines for management of database systems on Red Hat LINUX and Windows server systems;
6. Providing network support services for database-related network technologies and adapters such as TNS, ODBC, JDBC, OLEDB and .Net; and
7. Assisting in the establishment and enforcement of database administration policies, standards and procedures.
8. Collaborating with business experts to develop and document database infrastructure or design requirements;
9. Performing database design, data modeling and data administration;
10. Developing and documenting data standards
11. Maintaining the enterprise data dictionary and model repository; SOW 25-26-022 2
12. Utilizing data administration tools to construct data profiles, perform data analysis and provide data cleansing recommendations;
13. Providing support, diagnostic, troubleshooting and resolution of web-based and client server software applications in a distributed computer systems environment;
14. Project planning related to maintenance and lifecycle management for multiple distributed systems;
15. Administration and support for multiple statewide applications; and
16. Assisting in the establishment and enforcement of database administration policies, standards and procedures.