Short Description:
The SQL DBA will be responsible for data analysis and database management. The DBA will also be responsible for maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning.
Complete Description:
On-Site Support Only
No mulit-layering. All candidates should be direct to submitting vendor.
In addition, this person will be also be responsible for developing and qualifying database release management/deployment procedures and collaborating with the Software Development, Quality Assurance, and Support teams.
Qualifications:
Bachelors Degree in Computer Science or related technical field
Microsoft SQL Server Database Administration experience (3+ years), managing multiple MS SQL 2000,2005, 2008,2012 instances
Experience in data modeling and design including strong knowledge of SQL (T-SQL & ANSI SQL)
Thorough knowledge of data backup/recovery/rollback
Hands-on replication server knowledge (setup and troubleshooting)
SQL Server 2000, 2005, 2008,2012 optimization, fine-tuning, and scalability techniques
Data security and strong knowledge of network architecture and topology
Large-scale data migration experience (SQL Server 2000 - 2005)
DBA certification (i.e. MCDBA or otherwise) a plus.
Experience/knowledge of Data Warehousing concepts a plus
Experience in a fast-paced web development environment a strong plus
Familiarity with MySQL, UDB on LUW and PostgreSQL a plus.
Responsibilities:
Maintains central data repository.
Experience and knowledge in supporting application system development life cycle.
Responsible for data dictionary backup and recovery.
Responsible for definition of standards of data dictionaries.
May program dictionary analysis and maintenance software.
Perform performance tuning.
Monitor database performance and space requirements.
Schedule and monitor end of day data warehousing jobs.
Assist in coordinating software releases.
Communicate accurate and useful status updates.
Manage and report time spent on all work activities.
Follow quality standards.
Ability to work in a team environment
Complete assigned tasks.
Strong communication skills; both written and spoken ----Plus the following:
Business systems analysis and design experience.
Logical data modeling techniques.
Production environment Tools/Utilities.
Knowledgeable in data analysis and database management techniques.
Execution of all responsibilities with little direct supervision of Team Lead.
Administration and scripting experience in relative platform.
Supervise performance tuning.
Author shell scripts to perform back up, restore, and monitoring tasks.
Anticipate and resolve issues specific to the team.
Determine time estimates and schedule for own work and resolve issues in a timely manner.
Identify and track issues, risks and action items. Plus the following: Highly skilled at database design, installations, conversions.
Responsible for database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management.
Participates in Database Management System selection and maintains database performance.
Expertise in specific Database Management Systems.
Knowledge of various Database Management System products.
Provide status of work to Project Team Lead.
Engage in ongoing process improvement.
Skills:
Skill
Required / Desired
Amount
of Experience
SQL DBA
Required
7
Years
T-SQL & ANSI SQL
Required
4
Years
SQL Server 2000,2005, 2008, 2012
Required
4
Years
Large-scale data migration experience
Required
4
Years
Server 2008/2012 optimization
Required
4
Years
Data Warehousing concepts
Highly desired
MySQL, UDB on LUW and PostgreSQL
Highly desired
MCDBA
Required