Senior SQL DBA

Date Posted: May 13
Type: Permanent
Wage: Open
Job Number: 7529
Location: Houston, TX


LOCATION: West Houston

TYPE: Direct Hire


The Senior SQL DBA will administer, monitor, maintain and tune the Microsoft SQL Server databases that house production, UAT, QA and development data for the business. Identify database performance issues in a Microsoft SQL Server environment and implement solutions to address them. Gathering and reviewing SQL server performance metrics, performance tuning of the database and SQL server environment, improving T-SQL in expensive stored procedures, and maintaining proper indexes.

- Requires 24x7 production support of SQL Clustered Server databases/applications
- Ability to design both logical and physical Clustered Server environment including SAN, OS and DB Engine configuration standards
- Maintain Data integrity through backup and recovery utilities; Query Optimization; Database tuning; Coding Triggers, Complex Views, Indexes and Stored Procedures
- Comprehensive knowledge of database administration (design, installation & troubleshooting) of current MS SQL Server, and Windows Server Enterprise platforms
- Systems administration on operation systems with the Windows server family (Windows 2003/2008, 2012 Enterprise Clustered Environments)
- Perform indexes and stored procedure tuning; handle security, backups and recovery
- Programming using SQL and Windows scripting tool
- Extremely detail-oriented and able to follow standard methodologies for troubleshooting and development
- Implementation and troubleshooting of MySQL
- Experienced in SQL Reporting, Analysis Services, Integration Services
- Database performance and optimization experience with very large databases utilizing SAN storage
- Experience working with a Clustered Server database environment
- Industry-leading knowledge of high volume complex SQL Server database environments
- Skillful working knowledge of the physical data model design and DDL
- Serve as a Subject Matter Expert for assigned databases
- Develop and implement data security guidelines while making data available to those authorized to have access
- Ensure the technical integrity of corporate databases by protecting against the loss or misuse or information and designing backup/recovery strategies
- Provide database design, implementation and performance tuning consulting services
- Understand the business needs and develop effective, scalable and maintainable database instances to meet the business requirements deadlines and deliverables

- 5+ years building and managing SQL Servers
- 2+ years SQL programming experience building high volume, mission critical, data-driven applications
- 5+ years of experience with SQL Server, Full lifecycle development of complex system and application software
- SQL Server 2012/2008/2005/2000 experience
- SSIS/DTS programming
- Table and index design with optimization in high volume batch load environments
- Experience with partitioning, mirroring and replication
- Working knowledge of programming languages such as .NET / C# or others
- Creating SQL Server extended stored procedures
- Experience with ODBC and ADO.NET
- Experience with MySQL
- Microsoft certification a strong plus

- Bachelor’s Degree in MIS or CIS or equivalent job experience

Hot Jobs for the week of 07/15/2019

Clearpoint is a staffing agency for jobs in information technology, marketing, creative, and other professionals. We do business by building long-term, mutually beneficial relationships with our employees and clients.