Database Administrator

Database Administrator

 

 

A global provider of business services to the Fortune 1000, seeks a Database Administrator to join our fast-paced Information Technology Department, located in the Ballantyne area of South Charlotte.  The general purpose of this position is planning, maintaining, documenting & developing databases while incorporating consistent, clearly defined data, maximum efficiency, suitable user access data, data security & recovery control. 

 

 

RESPONSIBILITIES/DUTIES: 

 

· Establishes the needs of users

· Plans data flows for a new or revised database

· Reviews, develops, and designs data models using standard diagramming techniques, in conjunction with application development teams

· Creates logical data models and translates into physical database structures that integrate with existing or proposed database structures

· Maintains development, test, and production RDBMS environments

· Tests new systems

· Writes and maintains database documentation, including data standards, data models, procedures and definitions for the data dictionary ('metadata')

· Controls access permissions and privileges; monitors and maintains database security and database software

· Trains users and provides advice to applications programmers in the effective use of database languages; advises on troubleshooting, exception processing needs, and other data management issues

· Monitors and manages database backups, logs, and journals; installs, maintains, and upgrades database software; restores and/or recovers data as required

· Ensures disaster recovery procedures related to data recovery are in place, effective, and tested

· Monitors relational databases to optimize database performance, resource use, and physical implementations of databases

· 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

· May provide 24 hour on-call support

· Maintains currency of knowledge with respect to relevant state-of-the-art technology, equipment, and/or systems

· Evaluates and recommends testing and evaluation of new procedures, software, and hardware

· Maintains surplus system capacity

· Works closely with IT project managers, database programmers and web developers

· Communicates regularly with technical, applications, and operational staff, to ensure the database integrity and security

· Commissions and installs new applications

· Assists with special projects and other company efforts

· Participates in appropriate meetings, seminars and training sessions to stay abreast of new technologies that are useful to solve business problems

 

MINIMUM QUALIFICATIONS:

 

· Bachelor’s degree in Computer Science, Engineering or related field

· Three or more years of experience in database administration

· Knowledge of current technological developments/trends in area of expertise

· Knowledge of computer and/or network security systems, applications, procedures, and techniques

· Knowledge of data integrity methods and techniques

· Three or more years experience working with Microsoft SQL Server, preferably in a clustered environment

· Experience working with Microsoft SQL Server 2005

· Experience working with data modeling tools, such as ERwin

· Knowledge of data warehousing is a plus

· Experience with Oracle and/or Linux is a plus

· Ability to interpret data models and to develop database structures

· Ability to provide technical guidance and leadership to professional personnel in area of expertise

· 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 operate on a scheduled 24-hour on-call basis

· Ability to perform acceptance testing on computer systems, applications, and hardware

· Ability to install, maintain, modify, and upgrade database software

· Ability to solve practical problems and carry out responsibilities with minimal assistance from executive management

· Superior verbal and written communication skills, including formal presentation skills and technical writing skills

· Ability to interact effectively at all levels and across diverse cultures

· Ability to function as an effective team member

· Ability to adapt as the external environment and organization evolves

· Demonstrated ability to manage priorities and execute efficiently

· Demonstrated ability to work with clients to gather requirements and translate business needs into technology solutions.

· Demonstrated ability to construct project plans and meet scheduled feature, cost, and time goals