Administrator- Database III USA

Description

• Performance - Ensuring maximum performance given budgetary constraints.
• Configuring Replication / Data Synchronization.
• 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.
• Availability - Ensuring maximum uptime.
• 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.
• Required to use hands to grasp, lift, handle, carry or feel objects on a frequent basis
• Will sit, stand or walk short distances for up to the entire duration of a shift.
• Lead Major initiatives and mentor other admins.
• 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 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.
• 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.
• Security - Defining and/or implementing access controls to the data, OS and DB level security patching.
• Assesses, analyses, develops, documents and implements changes based on requests for change.
• 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.
• Setting up Base lining and Capacity Planning.
• Will lift, push, or pull up to 27 pounds on an occasional basis.
• SQL Server Database Monitoring – Preventive alerts.
• 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.
• Support IT Initiatives, process, and procedures around SOX controls.
• 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.
• Recoverability - Creating and testing Backups, optimize existing database backup procedures to ensure integrity, and to improve recoverability.
• 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.
• 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.
• 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.
• May stoop, kneel, or bend, on an occasional basis.
• 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.
• 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.
• Integrity - Verifying or helping to verify data integrity.
• 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.
• 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.
• Will climb stairs on an occasional basis.
• Architect solutions and document policies and procedures for major database initiatives.

Requirements

• Must be able to serve Database on-call on a routine basis.
• Ability to understand the integration and work with the enterprise applications.
• Knowledge of fault detection and resolution processes.
• Physical and logical database design.
• Advanced skills in database performance factors, backup, recovery, monitoring tools and tuning procedures.
• Working knowledge and/or prior experience in Cloud Data/Database administration a plus.
• Advanced skills with SQL, query writing and tuning.
• 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).
• Experience with SSAS (SQL Server Analysis Services).
• 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).
• Experience with SSIS (SQL Server Integration Services).
• Bachelor’s degree in information technology or related field or equivalent years of work experience.
• Global Player, work in “follow-the-sun” environment.
• Minimum 7 years of database administration work experience with Microsoft SQL Server.
• Familiarity with PowerShell scripting is a plus.
• Working Experience on Windows Mirroring and MS Cluster and Replication.
• Advanced skills in maintenance tools and procedures.
• Advanced skills with debugging stored procedures and triggers.
• Knowledgeable of ITIL practices and methodologies (i.e. Incident, Problem, and Change Management).
• Supportability – DB Server Upgrades and cumulative packs to the latest version.
• Advanced skills in productivity factors and ability to understand impact of problem on overall database performance.
• May reach above shoulder heights and below the waist on a frequent basis
• Must be able to comply with all safety standards and procedures
• 20/40 vision in each eye, with or without correction, is required
• Minimum 7 years of database administration experience with Microsoft SQL Server.
• SQL Server Consolidation & Virtualization.
• Familiarity with third party backup software is a plus.
• Ability to define physical and logical data structures.

Benefits

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

Training + Development

Interview process

Visa Sponsorship

Security clearance