Administrator- Database III

Basic Job Functions

• Performs advanced level administration activities in the SQL Server database domain. Develop, maintain, and implement policies and procedures and best practices that ensures availability, security and integrity of the First Solar’s databases. Implements data models and database designs, data access and table maintenance codes; resolves database performance issues, database capacity issues, replication, and other distributed data issues. Architect solutions for major database initiatives and work with other architects to ensure solutions are reviewed appropriately before implementation.
  
  Mentor other team members in the best practices of database administration.

• Minimum 7 years of database administration work experience with Microsoft SQL Server.
• Bachelor’s degree in information technology or related field or equivalent years of work experience.
• Minimum 7 years of database administration experience with Microsoft SQL Server.
• Advanced skills in database performance factors, backup, recovery, monitoring tools and tuning procedures.
• Advanced experience of MS SQL Server and Windows technology like Database Clustering especially complex SQL Always On clusters, Mirroring, Table Partitioning, Log Shipping, and Data Replication.
• Advanced skills in SQL Server Upgrades (Cumulative Packs and version upgrades).
• Different ways of database backup and restore processes.
• Advanced skills with SQL, query writing and tuning.
• Advanced skills with debugging stored procedures and triggers.
• Advanced skills in productivity factors and ability to understand impact of problem on overall database performance.
• Knowledge of fault detection and resolution processes.
• Advanced skills in maintenance tools and procedures.
• Familiarity with Power Shell scripting is a plus.
• Ability to define physical and logical data structures.
• Ability to understand the integration and work with the enterprise applications.
• Experience with SSIS (SQL Server Integration Services).
• Experience with SSAS (SQL Server Analysis Services).
• Setting up Base lining and Capacity Planning.
• Working knowledge and/or prior experience in Cloud Data/Database administration a plus.
• Familiarity with third party backup software is a plus.

• Lead Major initiatives and mentor other admins.
• Architect solutions and document policies and procedures for major database initiatives.
• Physical and logical database design.
• Recoverability - Creating and testing Backups, optimize existing database backup procedures to ensure integrity, and to improve recoverability.
• Integrity - Verifying or helping to verify data integrity.
• Security - Defining and/or implementing access controls to the data, OS and DB level security patching.
• Availability - Ensuring maximum uptime.
• Supportability – DB Server Upgrades and cumulative packs to the latest version.
• Performance - Ensuring maximum performance given budgetary constraints.
• Development and testing support - Helping programmers and engineers to efficiently utilize the database.
• Identify offensive SQLs and implement best practices for DBAs and development teams to follow.
• Working Experience on Windows Mirroring and MS Cluster and Replication.
• Knowledgeable of ITIL practices and methodologies (i.e. Incident, Problem, and Change Management).
• Support IT Initiatives, process, and procedures around SOX controls.
• Must be able to serve Database on-call on a routine basis.
• Global Player, work in “follow-the-sun” environment.
• Conducts security risk and vulnerability assessments for defined business applications or IT installations in defined areas, and provides advice and guidance on the application and operation of elementary physical, procedural and technical security controls (e.g. the key controls defined in ISO
  27001). Performs risk and vulnerability assessments, and business impact analysis for medium size information systems. Investigates suspected attacks and manages security incidents.
• Maintains knowledge of specific technical specialists provides detailed advice regarding their application and executes specialized tasks. The specialism can be any area of information or communication technology, technique, method,…