What are the responsibilities and job description for the Database Administrator position at Trick Dog Technology?
Under general supervision of the Chief Information Officer or designee, provides technical expertise in the design, implementation, and maintenance of relational database management systems (SQL and Oracle) that support institutional business applications. Ensures logical data models are mapped effectively and efficiently into physical data models that take advantage of the characteristics of the specific database management system used. Responsible for technically supporting multiple databases that run countywide business applications which are accessed by multiple departments. Maintains confidentiality of all privileged information.
The genera / / eve / and nature of this position are described in the headings below. This is not an a / / inclusive list ofa / / responsibilities, duties, and ski / / s required ofpersonne / in this c / assification. Duties, responsibilities and activities may change at any time with or without notice.
Essential Duties and Responsibilities :
Reviews, develops, and designs data models using standard diagramming techniques; creates logical data models and translates into physical database structures that integrate with existing or proposed database structures.
Monitors relational databases to optimize database performance, resource use, and physical implementations of databases; addresses a variety of database integration issues including migration between disparate databases, integration, maintenance / conversion, capacity planning issues, and new applications.
Maintains multiple development, test and production database environments.
Monitors and maintains database security and software, in cooperation with systems administrators. Ensures support is provided to customers in a professional, courteous, and timely manner.
Provides recommendations to applications analysts in the effective use of database languages; advises on troubleshooting, exception processing needs, and other data management issues.
Develops and manages multiple linked databases to include security, data safety and integrity, disaster recovery, and development and implementation of bulk data import / export procedures. Responsible for coordinating and managing technology projects of varying complexity, on time and within budget.
Maintains availability and integrity of databases through multiple access schemes; facilitates sharing of common data by overseeing proper key and index management and data dictionary maintenance. Evaluates and recommends testing of new database related procedures, software, and hardware. Monitors and manages database backups, logs, and journals; installs, maintains, and upgrades database software; restores and / or recovers data.
Creates, procures and maintains various database related documents such as manuals and programmers handbooks.
Job Description and Classification
Database Administrator 219
Maintains a broad knowledge of state-of-the-art technology, equipment, and / or systems; participates in professional development activities.
Ensures strict confidentiality of all information and records.
Contributes to a team effort and accomplishes related results as required. Performs other duties as required.
Minimum Qualifications :
Bachelor's Degree from an accredited college or university in Computer Science, Information Technology, Management Information Systems, Library Information Systems or related field or equivalent combination of education and related work experience.
Four years of experience in database management, troubleshooting and customer support experience.
Must possess current Oracle Database or Microsoft Database certification.
Successful completion of thorough background investigation, including FBI fingerprint check. Must not have been convicted of a felony.
Preferred Qualifications :
Both Oracle DBA Certification and MS SQL Server Certification.
Knowledge, Skills, and Abilities :
Knowledge of current technological developments / trends.
Knowledge of federal copyright laws as they pertain to the use of computer software.
Knowledge of computer security procedures and protocol
Knowledge of data integrity methods and techniques.
Knowledge of computer and / or network security systems, applications, procedures, and techniques. Knowledge of standard Microsoft desktop applications, Oracle and SQL server / databas
Skill in managing projects, in planning and adhering to schedules, and in working as an individual contributor and a team member.
Skill in technical writing and documentation.
Skill in report writing and programming.
Skill with business intelligence software.
Ability to provide technical guidance and leadership to professional personnel in area of expertise.
Ability to interpret data models and to develop database structures.
Ability to use standard diagramming techniques to design and develop computer data models.
Ability to implement and troubleshoot programming changes and modifications.
Ability to program, configure, manage, and maintain the operation of complex relational databases.
Ability to develop and manipulate large, complex data sets.
Ability to establish and maintain professional relationships with individuals of varying social and cultural backgrounds and with co-workers at all levels.
Ability to install, maintain, modify, and upgrade database software.
Ability to perform acceptance testing on computer systems, applications, and hardware.
Ability to act in an independent and conscientious manner using sound judgment and memory.
Ability to be analytical, highly organized, self-motivated, and client-oriented. Ability to communicate effectively, both orally and in writing.
Work Environment :
Work is performed in a professional office environment with a moderate noise level, occasionally working under stressful conditions and for extended periods of time. This position routinely uses standard office equipment such as computers, phones and photocopiers. Evening, holiday, and weekend work outside of normal business hours may be required as well as travel and attendance at meetings. Must be available for planned and emergency maintenance and to provide customer support 7x24x365 for enterprise environments.
