Job Description:
 |
EZ Search has a client based in Juno Beach, FL which is seeking to hire a SQL DBA on a direct basis. This position includes a competitive salary and comprehensive benefits package. Relocation assistance is not offered. Email resume for immediate consideration.
Reporting to the Host Systems Manager, the individual will be responsible for all aspects of database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL servers. In addition, this role will manage the cloning of data from production to additional environments, and application optimization including performance tuning, query optimization and supportability.
Duties/Responsibilities
• Configuration and maintenance of databases on clustered servers replicated across multiple data centers in a 24/7/365 high transaction environment
• Occasional after hours maintenance and upgrade work
• Maintenance and tuning of databases and replication
• Converting all existing databases to SQL 2008
• Production support, software maintenance, troubleshooting, and backup/recovery
• Grant access and system privileges to users
• Enterprise database architecture and guidance on database design
• Various manual data changes including documentation
• Troubleshoots database, software and related systems
• Advanced knowledge of SQL Profiler and server side traces to improve SQL performance
• Supports all Database systems in accordance with department guidelines
• Establishes change request process and adheres to said process
• Assumes and performs other duties and responsibilities not specifically outlined
herein, but which are logically and properly inherent to this position.
• Adherence to established disaster recovery policies and procedures – including, but not limited to backups, configuration/change management, and database documentation.
• Establish and Support a monitoring system to improve performance
• On call support
• Maintain confidentiality of proprietary information.
•
• Qualifications/Requirements:
• BS in Computer Science or equivalent
• 4+ years experience in the design and implementation of databases
• 7+ years senior level experience acting as a database administrator of Microsoft SQL Server 2000 or higher
• 4+ years experience with SQL Server 2005
• SQL Server 2008 experience is a plus
• Experience with performance tuning and replication
• 5+ years of Transact-SQL experience
• Strong experience on performance tuning, data integrity, data retention and efficiency.
• Strong experience in data analysis and data input/output processing.
• Experience in migrating from SQL 2000 to SQL 2005 to SQL 2008
• Experience in analyzing and writing complex queries and stored procedures
• Must have experience with data modeling and architecture
• Must be familiar with PCI and JSOX regulatory compliance
• Advanced relational development experience (i.e. normalization, referential integrity, stored procedure, Trigger)
• Experience with virtualization, clustering, replication, hardware replication, and disaster recovery
• Strong working knowledge of log shipping, peer-to-peer replication, SQL partitioning, service brokers, monitoring and alarming
• Strong hands-on technical aptitude
• Certifications in specific technologies preferred but not required
• Strong troubleshooting and problem resolution skills
• Strong process experience preferred
• Experience with ERP systems preferred but not required
|
