SQL Server DBA

Deerfield, Illinois

Employment Type:
Date Added:
June 10, 2015

Palace Gate Corporation is currently hiring for a SQL Server DBA in Chicago’s suburbs. This is a full-time position.

Duties and Responsibilities:

· Installation, operation and maintenance, performance monitoring and support, backup and recovery, security management, and insuring the availability of the SQL databases and SQL Server operating system.

· Providing technical support for SQL Database tools, software development, and performance issues.

· Monitoring database sizes, availability of disk space for databases,

· Managing databases within SQL Clustered SAN environment for performance optimization.

· Help manage a complex production database environment which includes over a half dozen production SQL Server SAN systems, plus additional non production instances/systems

· Coordinate with other managers to integrate with projects, applications and/or initiatives.

· Provide database and SQL Tuning expertise through recommendations to application developers, vendors and other core Application teams

· Perform SQL Server database capacity planning and performance monitoring

· Manage the storage environments for the SQL Server databases, including planning for additional storage, maintaining optimal sizing, monitoring space, and providing growth statistics.

· Create and execute SQL Server backup and recovery policies, and maintain integrity and reliability of access to information.

· Troubleshoot database issues including collecting information through traces and other logging facilities

Education and Training:

· SQL Server 2005 Certification or higher

Professional Experience:

· 5+ years of hands-on experience as an SQL Server DBA, working directly with SQL Server handling 2-10+ TB databases

Technical Requirements:

· Strong knowledge in the use of SQL Server Tools/utilities: DTS/SSIS/SSRS/SSMS, Encryption

· Strong knowledge of SAN attached storage, Windows Server 2003/2008, Windows clustering, Active Directory authentication and IP, TCP, UDP networking infrastructure

· Sybase technology highly desirable

· Advanced skills, including a disaster recovery background, on the Microsoft platform and VM technologies

· Extensive knowledge of platform specific advanced database features such as SQL clustering, database encryption, transactional replication, database mirroring, log shipping

· Full lifecycle experience surrounding large scale data management solutions

· Experience in the use of Windows Clustering/Networking, Partitioning and indexing

Knowledge and Abilities:

· Strong collaboration and communication skills

· Comfortable with ambiguity as needs change on a regular basis with a high degree of initiative and sense of urgency

Please send resumes to: mailto:patti@palacegatecorp.com

Palace Gate Corporation is an information technology consulting and full-time placement firm that is committed to the success of our clients and our talented placements alike. Palace Gate is consistent in matching the right people with right opportunity. Our company approach is simple: understand our clients’ requirements, business needs and cultures in order to quickly identify the best resources to meet those needs and achieve business success.

For more information or to view all our open jobs please visit: www.PalaceGateCorp.com