Administrator- Database III

Title : Sr. SQL Database Architect

Type : Direct Hire

Location : Perrysburg, OH (Onsite)

Client : First Solar

Rate : $130k yearly

Interview Mode : MS Teams and in person

JOB DESCRIPTION

First Solar reserves the right to offer you a role most applicable to your experience and skillset. 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.

Primary Responsibilities:

• 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. Skip to main content. Knowledgeable of ITIL practices and methodologies (i.e.  Incident, Problem, and Change Management).
• Support IT Initiatives, processes, 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. Key Competencies: 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 ISO27001).
• 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, product or application area.
• Maintains awareness of opportunities provided by new technology to address challenges or to enable new ways of working. Within own sphere of influence, works to further organizational goals, using emerging technologies and products. Contributes to briefings and presentations about their relevance and potential value to the organization. Undertakes routine installations and de-installations of items of hardware and/or software. Takes action to ensure targets are met within established safety and quality procedures, including, where appropriate, handover to the client. Conducts tests of hardware and/or software using supplied test procedures and diagnostic tools. Corrects malfunctions, calling on other experienced colleagues and external resources if required. Documents details of all hardware/software items that have been installed and removed so that configuration management records can be updated. Develops installation procedures and standards, and schedules installation work.

Required Skills/Competencies:

• 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 PowerShell 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). SQL Server Consolidation & Virtualization.
• Setting up Base Lining and Capacity Planning. Configuring Replication / Data Synchronization. SQL Server Database Monitoring - Preventive alerts. Working knowledge and/or prior experience in Cloud Data/Database administration a plus.

Education/Experience:

• 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.