SQL Server/Oracle Database Administrator Kelly IT Resources has an opportunity for a SQL Server DBA for a client in Detroit, Michigan. This position is an open ended contract. Kelly IT Resources is among the largest and most respected technology recruitment firms in the country.
JOB DESCRIPTION:
Working under the general supervision of the Technical Manager, will provide enterprise database support for all databases. Responsible for installing configuring, and maintaining database environments. Evaluates and installs patches and resolves database-related problems. Reports issues and documents events in accordance with established procedures. Works closely with developers. Ensures proper database backups and recovery. Maintains data files and monitors system configuration to ensure data integrity. Secondary responsibilities may include providing Windows 2003 / 2008 system administration support (e.g., working with AD, Group Policies, NTFS / shared folder rights, and troubleshooting).
Preferred Technical Skills:
- 8+ years of experience in database administration, development and support in enterprise database environments (SQL Server, Oracle)
- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues and security issues
- Experience in performance tuning, query optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
- Ability to detect and troubleshoot database-related issues involving CPU, memory, I/O, disk space and other resource contention
- Knowledge of database backups/restores, recovery models, database shrink operations, clustering, database mirroring, disaster recovery and replication
- Experience in implementing operational automation on the database
- Knowledge of indexes, index management, integrity checks, configuration, and patching. Also, knowledge of how statistics work, how indexes are stored, and how indexes can be created and managed effectively
- Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system procedures)
- SQL Development - ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints)
- Documentation skills for processes and procedures (creating KBs, data maps, etc )
- Ability to provide database operational support to technical users
- Ability to provide System Administration support in a Windows 2003 / 2008 environment
Responsibilities may include:
- Design and document database architecture
- Data Modeling
- Build database scheme, tables, procedures and permissions
- Develop database utilities and automated reporting
- Create scripts/procedures/jobs for task automation
- Create, test and execute data management languages
- Analyze and sustain capacity and performance requirements for the databases
- Analyze, consolidate and tune databases for optimal efficiency
- Oversee database backup, clustering, mirroring, replication and failover
- Restore and recover corrupted databases
- Install and test upgrades and patches to the databases
- Implement access security on the databases
- Provide 24/7 support for critical situations
- Evaluate and recommend new database technologies
- Maintain Active Directory environment
- Create / maintain Group Policies
- Provide user access to shares
- Other duties as assigned by the Technical Manager
Kelly IT Resources (KITR) is a specialty service of Kelly Services, Inc., a leader in providing workforce solutions. Launched in 1999, KITR provides information technology specialists across all IT disciplines, including operating systems, programming languages, database administration, application development, website design and development, networks, e-commerce, ERP development, software engineering, and project management. Visit us at .
|
