<p><strong>Senior Database Administrator</strong></p> <p><span><span>The Senior Database Administrator ensures maintaining the databases in good working order and performing tasks necessary to ensure continued growth and stability of the database.</span></span></p> <p> </p> <p><span><span><strong>Roles and responsibilities</strong></span></span></p> <p><span><span>Database Administration tasks.</span></span></p> <ul> <li><span><span>Install and configure SQL Server.</span></span></li> <li><span><span>Setup and maintain SQL Server account security.</span></span></li> <li><span><span>Performs SQL backups and restores.</span></span></li> <li><span><span>Setup, schedule, and troubleshoot SQL Server jobs.</span></span></li> <li><span><span>Applies updates and upgrades to production database environments.</span></span></li> </ul> <ul> <li><span><span>Read requirement documents and Design Databases based on them and preparing ER diagrams</span></span></li> <li><span><span>Writing Database code including stored procedures and triggers</span></span></li> <li><span><span>Setup and run SQL Server Profiler traces.</span></span></li> <li><span><span>Optimize SQL queries and suggest alternative methods to enhance the efficiency.</span></span></li> <li><span><span>Identify potential performance / security vulnerabilities and bad coding patterns and propose / implement solution to overcome those.</span></span></li> </ul> <p> </p> <p> </p> <p><span><span><strong>Education and/or Experience</strong></span><strong> </strong></span><span><span><strong><span> </span> </strong></span></span></p> <ul> <li><span><span>Bachelor’s degree in Computer Science / IT</span></span></li> <li><span><span>5 Years’ experience in Development / Database administration</span></span></li> </ul> <p> </p> <p><span><span><strong>Knowledge, Skills and Abilities</strong></span></span></p> <p><span><span>Key Technical Competencies</span></span></p> <ul> <li><span><span>Proficient in OOP concepts</span></span></li> <li><span><span>Proficient in Microsoft SQL Server administration , preference on the latest Version</span></span></li> <li><span><span>Proficient in Structured Query Language (SQL)</span></span></li> <li><span><span>Knowledge in writing Stored Procedures</span></span></li> <li><span><span>Knowledge in relational database design</span></span></li> <li><span><span>Knowledge in SSIS</span></span></li> <li><span><span>Knowledge in scripting languages</span></span></li> <li><span><span>Knowledge of database driven Internet applications</span></span></li> <li><span><span>Exposure to MS SQL Server production Database administration</span></span></li> <li><span><span>Coding skills in multiple languages desired in at least one language is essential</span></span></li> </ul> <p> </p> <p><span><strong><span>Other Competencies</span></strong></span></p> <ul> <li><span><span>Ability to be flexible and adapt to any given situation</span></span></li> <li><span><span>Ability to perform multiple tasks concurrently in a high stressed environment</span></span></li> <li><span><span>Excellent customer service attitude, communication skills (written and verbal), and interpersonal skills</span></span></li> <li><span><span>Excellent organizational and time management skills</span></span></li> <li><span><span>Excellent analytical and problem-solving skills</span></span></li> <li><span><span>Ability to work independently and in a team based environment</span></span></li> </ul> <p> </p> <p><span><strong><span>License/certifications required</span></strong></span></p> <ul> <li><span><span>Preference given to MCITP – DBA certified professionals </span></span></li> </ul> <p> </p> <p><strong><span><span>Please click the link to apply </span>http://pearsonlankavacancies.peopleshr.com/</span></strong></p>