Information Systems Sql Server

Sr Oracle DBA

Under minimal direction, lead with the creation, maintenance, quality control, auditing, upgrades, and overall performance of complex databases using Oracle. Microsoft SQL Server, common system analysis tools, and other open-source tools and database products. Frequently leads in resolving difficult database issues, creatively utilizing knowledge gained from experience. Assists database client users with setting up proper client access to databases as needed. Provides training and coaching to team members and in other technical areas regarding proper database operation, performance, and testing. Assists management and provides input to work plans for continued database management and operation.

REPRESENTATIVE DUTIES

This list is intended to indicate the general nature and level of work performed by employees within this classification and is not designed to be interpreted as an exhaustive listing of all tasks required of employees assigned to this job.

1.Acts as a consultant to management and Information Systems team members, regarding database usage and may provide direction to team members in all areas of professional responsibilities.

2.Lead team(s) of people who have responsibility for strategy and development, including systems and application development, vendor management, and legacy systems integration.

3.Facilitates communication between all key Information Systems teams and the customer community via participation in meetings and the creation of status reporting mechanisms (weekly, monthly, and quarterly). Represents Information Systems and participates in enterprise-wide technology projects for critical projects and new technologies.

4.Leads installation of Oracle, Microsoft SQL Server, and other open-source databases and tools including clustered and high-availability software and hardware environments.

5.Follows and maintains all Change Control and Audit requirements.

6.Leads with research and the requirements for software compatibility within the Enterprise Architecture.

7.Coordinates software user acceptance testing activities for new installations, maintenance, and upgrade activities.

8.Assists in the development of Information Systems standards and policies to ensure compatibility and integration throughout the enterprise.

9.Leads in the collection and analysis of performance data from databases, database tools, system analysis tools, and other open-source tools as provided by the Authority.

10.Leads with determining when databases require tuning, maintenance, and reorganization and appropriately advises database lead, information systems teams, and management.

11.Leads with the development of data models of the Authority’s database environment(s) to ensure a unified database and uniform database policy methodologies.

12.Leads in the planning, installation, upgrade, and maintenance of complex database systems, software, and tools to maintain the software, and or firmware at the most current revision levels possible.

13.Leads Information Systems staff with database design, problem solutions, monitoring, connectivity, and other technical issues related to database performance.

14.Leads in the maintenance of the procedures in the disaster recovery plan for database recovery.

QUALIFICATION GUIDE

Knowledge of:

Detailed knowledge of Oracle database products and current underlying operating systems.

Detailed knowledge of Microsoft SQL Server products and current underlying operating systems.

Understanding of Oracle cloud product offerings required.

Understanding of Microsoft SQL Server cloud offerings required.

Understanding of Common Database tools provided by Oracle, Microsoft, and other providers is helpful.

Data modeling using ERWIN, database structure and normalization techniques, tablespace and index management, tuning databases.

Interaction with Linux and Windows system administration in the area of disk usage management to provide for database space allocations.

Ability to:

An ability to present and discuss technical information in a way that establishes rapport, persuades others, and gains understanding.

Interface and resolve problems with various departments within the Authority.

Reduce complex data issues to their respective data entities and design and normalize relational databases.

Schedule various system maintenance items such as updating archival statistics; program medium to complex SQL statements.

Provide work direction to assist department staff and consultants to achieve proper project outcomes.

Provide input to management on staff and contractor performance related to the area of project assignments.

EDUCATION AND EXPERIENCE

Any combination of education and experience equivalent to a bachelor’s degree in computer science, information systems or related and a minimum of five years of complex analysis in programming or system administration with at least five years as a Oracle Database Administrator. Equivalent experience supporting complex and critical Information Systems environments will be evaluated in lieu of these requirements where applicable.

WORKING CONDITIONS/PHYSICAL ACTIVITIES

Work may be performed in a stressful, fast-paced office environment, depending upon assignment.

Requires ability to understand verbal communication and to respond effectively.

Positions in this class typically require: Reaching, Fingering, Grasping, Feeling, Talking, Hearing, Seeing, and Repetitive Motions in computer use.

Contact this candidate