Job Seekers, Please send resumes to resumes@hireitpeople.com

Primary Skills: 8+ years of related experience in SQL Server, including replication, HA and DR techniques. â—¦Strong aptitude for tuning T-SQL.
â—¦5 - 8 years’ related experience; or a Master’s degree with 3 years’ experience; or a PhD without experience; or equivalent directly related work experience.
â—¦8+ years of related experience in SQL Server, including replication, HA and DR techniques.
â—¦Strong aptitude for tuning T-SQL.
â—¦Experience in performance tuning, query optimization using Performance Monitor, SQL Profiler and other related monitoring/troubleshooting tools.
â—¦Process oriented engineer with strong execution and follow through skills. Self-starter.
â—¦Experience supporting SQL Server editions 2005-2014 in a production environment.
â—¦Strong working knowledge of Windows OS, physical hardware, storage systems, networking.
â—¦Experience with AlwaysOn, clustering, replication, virtualization and high transactional enterprise systems.
â—¦Strong written and oral communication skills.
â—¦Team player with ability to multitask with minimal supervision. Excellent analytical and problem solving skills.
â—¦Proven self-starter with initiative and ability to not only see the bigger picture but also effectively communicate to IT Management and SME’s in the business.



Plusses

-Working experience with SSAS, SSRS desired.
-SQL certification desired.



Day-2-Day *

We are seeking a motivated Senior to Principal level SQL DBA to join our existing team of 7 very capable SQL DBA’s supporting some of the most challenging deployments you’ll see using SQL Server.

Our SQL Server environment is responsible for the day-to-day operations of over 2,300 clinics:
•Financials platform: 7 TB OLTP, 12 TB OLAP/DSS database pushing 2.4 Billion database txn’s/day, 700 users, supporting $700M/month in revenue for FMCNA
•Clinical systems platform: 15 TB+ database, 1.5 Billion txn’s/day, 12,000 daily users, facilitating 80,000 treatments/day
•Transactional replication environment with over 150 Million commands per day
•Large scale servers, e.g. 160 processors, 2TB RAM
•Custom alerting and monitoring in support of critical systems
â—¦Central monitor server, monitoring 140+ instances
â—¦T-SQL, powershell, batch files
â—¦Operational dashboard using SSRS

•Responsible for administration, maintenance and availability of enterprise production environments.
•Ensure backup and recoverability of all enterprise databases.
•Ensure data security. Define and implement database access control policies and procedures.
•Works with Data Architect on long term strategy to ensure integrated database systems. Advise on physical data model and implement changes.
•Responsible for capacity planning, working closely with Infrastructure group to allocate appropriate database resources on servers.
•Contribute to the ongoing development of technology and production processes company-wide. Keep abreast of new design tools, hardware, software, and technology and make recommendations for future deployment.
•Provide technical leadership. Mentor junior staff on database technical details. Provide technical assistance to developers.
•Monitor server databases to ensure optimum performance, analyzing and resolving performance issues ensuring maximum uptime.
•Create and maintain quality control and auditing of databases.
•Develop and adhere to common database standards and procedures within a production operations unit. Maintain documentation related to database platforms, guidelines, methods and standards.
•Coordinate with technical project managers, developers and other team members to coordinate database requirements across projects.
•Triage/track outstanding issues, providing solutions to resolve defects and issues.
•Develop and adhere to common database standards and procedures within a production operations unit. Maintain documentation related to database platforms, guidelines, methods and standards.
•Interact with business users verifying or helping to verify data integrity.
•Responsible for administration, analysis, design, and creation of new SQL server databases.
•Document and improve existing processes related to operations and daily work.
•May escalate issues to supervisor/manager for resolution, as deemed necessary.
•Mentor other staff as applicable.
•Review and comply with the Code of Business Conduct and all applicable company policies and procedures, local, state and federal laws and regulations.
•Assist with various projects as assigned by a direct supervisor.