Administrator- Database III USA

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.

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.

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.
• Familiarity with third party backup software is a plus.

Essential Responsibilities:

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

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, by the use of 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. Provides specialist guidance and advice to less experienced colleagues to ensure best use is made of available assets, and to maintain or improve the installation service.
• Monitors service component capacity and initiates actions to resolve any shortfalls according to agreed procedures. Applies techniques to modify demand for a particular resource or service.
• Contributes to the availability management process and its operation and performs defined availability management tasks. Analyses service and component availability, reliability, maintainability and serviceability. Ensures that services and components meet and continue to meet all of their agreed performance targets and service levels. Implements arrangements for disaster recovery and documents recovery procedures. Conducts testing of recovery procedures.
• Performs defined tasks to monitor service delivery against service level agreements and maintains records of relevant information. Analyses service records against agreed service levels regularly to identify actions required to maintain or improve levels of service, and initiates or reports these actions.
• Assesses, analyses, develops, documents and implements changes based on requests for change.
• Assesses and analyses release components. Provides input to scheduling. Carries out the builds and tests in coordination with testers and component specialists maintaining and administering the tools and methods - manual or automatic - and ensuring, where possible, information exchange with configuration management. Ensures release processes and procedures are maintained.
• Reviews system software updates and identifies those that merit action. Tailors' system software to maximize hardware functionality. Installs and tests new versions of system software. Investigates and coordinates the resolution of potential and actual service problems. Prepares and maintains operational documentation for system software. Advises on the correct and effective use of system software.
• Investigates identified security breaches in accordance with established procedures and recommends any required actions. Assists users in defining their access rights and privileges, and administers logical access controls and security systems. Maintains security records and documentation.
• Investigates identified security breaches in accordance with established procedures and recommends any required actions. Assists users in defining their access rights and privileges, and administers logical access controls and security systems. Maintains security records and documentation.
• Maintains application support processes, and checks that all requests for support are dealt with according to agreed procedures. Uses application management software and tools to investigate issues, collect performance statistics and create reports.
• Ensures that appropriate action is taken to anticipate, investigate and resolve problems in systems and services. Ensures that such problems are fully documented within the relevant reporting system(s). Coordinates the implementation of agreed remedies and preventative measures. Analyses patterns and trends.
• Collects and collates evidence as part of a formally conducted and planned review of activities, processes, products or services. Examines records as part of specified testing strategies for evidence of compliance with management directives, or the identification of abnormal occurrences.
• Other duties as assigned.
• Job description subject to change at any time.

Reporting Relationships:

• Reports to Senior Managers.
• Will not have direct reports.

Travel:

• TBD

Estimated Salary Range:

• $89,100-$127,000 Annually.

US Physical Requirements:

• Will sit, stand or walk short distances for up to the entire duration of a shift.
• Will climb stairs on an occasional basis.
• Will lift, push, or pull up to 27 pounds on an occasional basis.
• Required to use hands to grasp, lift, handle, carry or feel objects on a frequent basis
• 20/40 vision in each eye, with or without correction, is required
• Must be able to comply with all safety standards and procedures
• May reach above shoulder heights and below the waist on a frequent basis
• May stoop, kneel, or bend, on an occasional basis.
• Ability to wear personal protective equipment is required (including but not limited to; steel toed shoes, gloves, safety glasses, hearing protection, protective jacket or apron and arm guards).

Office Physical Requirements:

All positions in our office require interaction with people and technology while either standing or sitting. In order to best service our customers, internal and external, all associates must be able to communicate face-to-face and on the phone with or without reasonable accommodation. First Solar is committed to compliance with its obligations under all applicable state and federal laws prohibiting employment discrimination. In keeping with this commitment, it attempts to reasonably accommodate applicants and employees in accordance with the requirements of the disability discrimination laws. It also invites individuals with disabilities to participate in a good faith, interactive process to identify reasonable accommodations that can be made without imposing an undue hardship.

Potential candidates will meet the education and experience requirements provided on the above job description and excel in completing the listed responsibilities for this role. All candidates receiving an offer of employment must successfully complete a background check band any other tests that may be required.

Equal Opportunity Employer Statement: First Solar is an Equal Opportunity Employer that values and respects the importance of a diverse and inclusive workforce. It is the policy of the company to recruit, hire, train and promote persons in all job titles without regard to race, color, religion, sex, age, national origin, veteran status, disability, sexual orientation, or gender identity. We recognize that diversity and inclusion is a driving force in the success of our company.