Administrator- Database III USA

FIRST SOLAR INC-posted about 1 month ago
Full-time • Mid Level
Perrysburg, OH
5,001-10,000 employees
Computer and Electronic Product Manufacturing
Resume
Match Score
Upload and Match ResumeTrack Jobs with Teal

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.

  • 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 ISO27001). Performs risk and vulnerability assessments, and business impact analysis for medium size information systems.
  • 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.
  • 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.
  • Minimum 7 years of database administration experience with Microsoft SQL Server.
  • Bachelor's degree in information technology or related field or equivalent years of work experience.
  • 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.
  • 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.
  • Familiarity with PowerShell scripting is a plus.
  • Working knowledge and/or prior experience in Cloud Data/Database administration a plus.
  • Familiarity with third party backup software is a plus.
Track Jobs with Teal

Job Search Resources

•
AI Resume Builder
•
Database Administrator Resume Examples
•
Database Administrator Cover Letter Examples

Tools

Career Hubs

Guides

Company

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service