SQL DBA

Job Description

Sr. DBAThe DBA is challenged to work with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives. Trains and develops technical support and applications staff to better utilize on-line processing databases environment. Provides and designs tools to assist in the management of the database and transaction processing environment. Works to provide a working model of our transaction processing environment for capacity assessment and planning.Develops a methodology for the ongoing assessment of database performance and the identification of problem areas. Develops a security scheme for the database environment, as well as assisting in disaster recovery if necessary. Provides leadership during the development and enhancement of production applications including working with applications, technical support and operations during the design, development and implementation of applications. Work with the transaction processing area to develop both the physical and the logical database administration functions and assists in the development of our processing database and computing environments. Work with others in IT to build the logical database area and provide technical guidance during all phases of the development process. Work with vendors in evaluating and implementing new technologies.Qualification (Education/Skill and Experience for the job;Degree in one of the following subject areas: Computer Science, Business Administration, Information Technology or related field preferredMicrosoft certification would definitely will be an added advantage5 - 8 years Microsoft SQL Server experienceUnderstanding of, and experience with, server-client computing and relational database environmentsExperience with data management and data processing flowcharting techniquesOn-call troubleshooting experience with at least one production SQL Server for a year. You dont have to be the only DBA or have DBA in your job description, but you should have been the one person that the company would call if the SQL Server service stopped working.Finding DMV queries to answer questions about server-level performanceAbility to diagnose server reliability and performance issuesKnowledge of reporting and query tools and practicesGood understanding of the organizations goals and objectivesGood interpersonal, written, and oral communication skillsTechnical documentation skillsAbility to present ideas in user-friendly languageSelf-motivated and directed, with keen attention to detailAble to prioritize and execute tasks in a high-pressure environmentExperience working in a team-oriented, collaborative environmentGood written and oral communication skillsSQL ServerDatabase AdministrationDatabase TuningDatabase ManagementDatabase SecurityRDBMSGood knowledge of OLTP and OLAP systems and experience in Data warehousing using SSAS / SSIS / SSRSJob DescriptionSr. DBADegree in one of the following subject areas: Computer Science, Business Administration, Information Technology or related field preferredMicrosoft certification would definitely will be an added advantage5 - 7 years Microsoft SQL Server experienceUnderstanding of, and experience with, server-client computing and relational database environmentsExperience with data management and data processing flowcharting techniquesOn-call troubleshooting experience with at least one production SQL Server for a year. You dont have to be the only DBA or have DBA in your job description, but you should have been the one person that the company would call if the SQL Server service stopped working.Finding DMV queries to answer questions about server-level performanceAbility to diagnose server reliability and performance issuesKnowledge of reporting and query tools and practicesGood understanding of the organizations goals and objectivesGood interpersonal, written, and oral communication skillsTechnical documentation skillsAbility to present ideas in user-friendly languageSelf-motivated and directed, with keen attention to detailAble to prioritize and execute tasks in a high-pressure environmentExperience working in a team-oriented, collaborative environmentGood written and oral communication skillsSQL ServerDatabase AdministrationDatabase TuningDatabase ManagementDatabase SecurityRDBMSGood knowledge of OLTP and OLAP systems and experience in Data warehousing using SSAS / SSIS / SSRS,

Keyskills :
microsoft sql serversql serverdata managementdata processinginformation technologybusiness administrationmicrosoft sqlsqlbusinessdatabasediagnosereportingmanagementreliability