Description
SQL Server DBA
Location: Atlanta (Downtown)
Our client in Atlanta, GA is looking for a SQL Server DBA (Production DBA) for an exciting opportunity. As a SQL Server DBA you will be responsible for developing and/or implementing timely, cost effective, and high quality database solutions.
As a SQL Server DBA will be responsible for:
Purpose:
This position interfaces closely with portfolio and business unit developers to design, implement, tune, and troubleshoot database solutions for new development projects, enhancements to existing solutions, and implementation of purchased vendor packages. A DBA ensures that proper creation, support, placement, performance and security are in place for data. Significant coordination is required with developers and infrastructure support groups for operating system upgrades, software upgrades, migrations, and hardware replacements.
Education/Experience:
Degree in Computer Science or a related field preferred
In-depth knowledge of DBMS related technologies (specifically SQL Server)
Job Responsibilities:
Develop and/or implement timely, cost effective, and high quality database solutions
Perform database maintenance, consisting of:
o DBMS and related software installs, upgrades and patches (including security patching)
o Logical and physical database design
o Structure modifications/schema management
o Database Reorganizations
o Space monitoring and management/Capacity planning
o Performance analysis and tuning (both at SQL and DBMS level)
o Data integrity checks and cleanup
o Database backups and recovery
o Disaster recovery
o Data loads
o Coding, maintaining and consulting on database procedures and triggers
o Troubleshooting DBMS and related problems
o Participate in on-call duty pager rotation
Consultation on database issues and tools with internal customers and other IT groups
Build and maintain relationships with customers, peers, staff and other IT groups
Provide project activities in compliance with the approved methodologies and standards
Provide root cause analysis, efficient production support and maintenance/enhancements for existing applications
Participate in special projects/assignments
Meet schedules and estimates for assigned tasks
Job Requirements:
In-depth knowledge of SQL Server R2).
Familiarity with SQL Server 2012.
Knowledge of clustering, log shipping, and Quest LiteSpeed.
Understanding of database support for Biztalk, Sharepoint or BI (SSIS, SSAS, SSRS) a plus.
Experience with database support of System Center (SCCM, SCOM) is a plus.
Understanding of typical DBMS SOX controls is a plus.
Working knowledge of Windows platform including Scripting, editors, etc.
Working knowledge and understanding of software development technologies, methodologies, and associated tools
Working knowledge of application architectures (Web, Client Server, Batch, etc.)
Working knowledge of typical IT organization and business units
Competencies:
Proven effective communication and interpersonal skills
Ability to negotiate and influence others
Ability to function independently and as a team member
Proven analytical and problem solving skills
Ability to lean new approved technologies and apply them
Excellent customer service skills
Ability to handle multiple assignments and conflicting priorities
Ability to quickly establish new, strong interpersonal relationships with customers, peers, and management associated tools
Working knowledge of application architectures (Web, Client Server, Batch, etc.)