SQL DBA, Practice Choice
McKesson Technology Services - Alpharetta, GA

This job posting is no longer available on Dice. Find similar jobs:SQL Database Administrator jobs - McKesson Technology Services jobs

Current Need McKesson Practice Choice is seeking a SQL DBA in our Alpharetta GA location The SQL DBA designs maintains and ensures high availability of a 24X7 SaaS production database system Heshe also plans and implements process improvement projects to streamline database changes across several environments Our ideal candidate should have experience working with application development teams in the delivery of software releases into production Position Description Responsible for Performance Tuning Query Optimization using Performance Monitor SQL Profiler and other related monitoring and troubleshooting tools Responsible for extensive applicationSQL monitoring troubleshooting tuning highavailability strategies in a Windows 2008 SQL Server 2008 24X7 production environment Develops and implements replication archiving and backup and recovery strategies Plans hardware requirements and storage capacity for production servers for scalable database growth Proactively monitors the Production Database and optimizes stored procedures for better performance resolves locking conflicts and resource utilization issues Administers maintains develops and recommends policies and procedures for ensuring the security and integrity of the company’s databases Manages and creates database schemas for Relational Database Systems (optimize index creation table creation storage allocations etc) Ensures all database environments (Development Staging QA and Production) are in sync Defines db scripts versioning system to keep track of database versions for all environments Designs reviews and implements production SQL Server database objects models and database designs(schema) Identifies and resolves database performance issues database capacity issues and other distributed data issues SQL Development – ability to write and troubleshoot SQL Code and design ( stored procs functions tables views triggers indexes constraints ) SQL Database Operational support for a larger team environment and support activities in SaaS environment Specify create and maintain database instances in Development and Training This includes consistency with standards data models and backup strategy for the database Lead the transition of database objects from Development to Production No agencies please Qualifications Minimum Requirements 6+ years experience in database administration Critical Skills 6+ years SQL Server Database Administration experience 2+ years experience in a Saas or hosted environment Strong understanding of relational database design and performance Strength in production support tasks debuggingsupporting code issues Strong SQL Server Integration Services (SSIS) Report Analysis and TSQL procedure development experience is required Experience of managing multiple MS SQL Server (2008 and 2012 preferred) RDBMS on large systems Experience with source control (Team Foundation Server 2008 or above is a plus) Experience Practical experience in monitoring and tuning a database to provide a high availability service Demonstrated ability to independently troubleshoot and resolve complex technical issues Understanding of full lifecycle methodology for commercial software products Familiar with Agile work environment Education 4year degree in computer science or related field or equivalent experience Physical Requirements General Office Demands Benefits Benefits Company Statement We believe you should be rewarded for the important work you do For that reason youll receive a competitive compensation and benefits package when you join our team It starts with you Thats a simple sentence but it says a lot It reminds each one of us that what we do matters Every single McKesson employee contributes to our mission whatever your title whatever your role you act as a catalyst in a chain of events that helps millions of people all over the globe By connecting and improving the business of healthcare were helping to ensure that millions of patients get the treatment they need And by choosing a career with McKesson Provider Technologies youll join a team of passionate people working together to improve lives and advance healthcare At McKesson we believe we can empower healthcare And it all starts with you As an equal opportunity employer McKesson Corporation unites the talents and contributions of all to advance the power of healthcare Learn more about our opportunities at mckessoncomcareers The material contained herein is provided for informational purpose only All open jobs offered by McKesson Corp on this recruitment system are subject to specific job skill requirements The job skill requirements qualifications and preferred experience are determined by a subsidiary office or department within the company which is offering the position and all positions are subject to local prevailing employment laws and restrictions This would include immigration laws pertaining to work authorization requirements and any other applicable government permissions or compliance The materials on this site are provided without warranties of any kind either expressed or implied including but not limited to warranties regarding the completeness of information contained on this site or in any referenced links While McKesson Corp attempts to update this site on a timely basis the information is effective only as of the time and date of posting By providing your application to McKesson Corp you hereby consent to McKesson Corp obtaining personal information regarding you that is related to the position applied for You also consent to McKesson Corp transferring your application details to our recruitment partners for their review and assistance You also consent to McKesson Corp keeping your application on file for 6 years McKesson Corp is an equal opportunity employer The information on this site is for information purpose only and is not intended to be relied upon with legal consequence