Lead Analyst - Database Support
Lead Analyst - Database Support
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Job Title: Lead Analyst Database Support SQL Server DBA
Department: Infrastructure Middleware & DB
Reports to: Supervisor Infrastructure Middleware & DB
Location: In Office Augusta ME Orange CT Rochester NY Vestal NY
The base salary range for this position is dependent upon experience and location ranging from: $111544.80 $139431
SQL Server DBA Job Description
Purpose
- Provides support for the AVANGRID SQL Server database environments & applications using SQL Server databases.
- Participate in all database system design maintenance and enhancement work and documentation.
- Proactively monitor and maintain all database and application systems for an uninterrupted service to the Energy Control Center (ECC).
- Analyze extract and make available system data for the engineers on request.
- Works within the Control Center environment and supports Cyber Security requirements for Control Center operations.
Key Technical Working skills
- Proficiency in Various SQL server installation and configurations on SQL Server 2019 and Experience in migrating from early versions of SQL Server to SQL Server 2019 and above.
- Strong background in SQL Server database administration including Query Optimization Performance Tuning Troubleshoot and Identify the issues on MSSQL 2016/2019.
- Experience in high availability methods like clustering and/or mirroring Always ON Availability Groups on a Multisite environments.
- Experience in applying database patches security patches and application patches.
- Maintain Stored Procedures Indexes SQL Jobs Alerts Special Procedures views functions SSIS in a multiserver environment.
- Ability to identify and troubleshoot the issues with Permissions Networking firewall AD group Ad Authentications and VMware etc.
- Ability to review the Audit requirement and apply the fixes if required.
- Experience with scheduling backups restoring databases using SQL native backups also knowledge on Veeam and/or Veritas backups.
- Experience on SQL Mail configurations and Notification for any Job failures as well proactive notifications like blocking Deadlock space issues etc.
- Strong Experience in Disaster Recovery (DR) tasks design implement and manage.
- Strong background in database and application Tuning and optimizing SQL statements in applications batch jobs and reports.
- Very good Indepth know of database security privilege assignment and design rolebased security.
- Experience in SolarWinds DPA is a plus.
- Experience in Datacenter Migrations is a plus.
General Knowledge & Skills
- Working with the understanding of relevant Industry Compliance Regulations and Policies.
- Performing scheduled maintenance and support release deployment activities after hours and/or during maintenance windows.
- Independently analyze solve and correct issues in real time providing problem resolution endtoend.
- Monitoring performance issues and for availability on all production and nonproduction databases (as applicable).
- The ability to demonstrate good communication skills both written and orally. Experience to make sound decisions will working in a highpressure environment outside normal working hours.
- Working in storm or other emergency conditions for 24x7 system support.
- Prior experience in working with Gas Utilities or any other utility industry is an advantage.
Requirements
- Education and Experience: (Must meet at least one of the following)
- Bachelors Degree with 2 years in RDBMS experience
- Associate Degree with 4 years in RDBMS experience
- 57 years IT and RDBMS related experience
Company:
CENTRAL MAINE POWER COMobility Information
Please note that any applicant who is not a citizen of the country of the vacancy will be subject to compliance with the applicable immigration requirements to legally work in that country
AVANGRIDs employment practices and policies are geared to hiring a diverse workforce and sustaining an inclusive culture. At AVANGRID we provide fair and equal employment and advancement opportunities for all employees and candidates regardless of race color religion national origin gender sexual orientation age marital status disability protected veteran status or any other status protected by federal state or local law.
If you are an individual with a disability or a disabled veteran who is unable to use our online tool to search for or to apply for jobs you may request a reasonable accommodation by contacting our People and Organization department at
Avangrid employees may be assigned a system emergency role and in the event of a system emergency may be required to work outside of their regular schedule/job duties. This is applicable to employees that will work in Connecticut Maine Massachusetts and New York within AVANGRD Network and Corporate functions. This does not include those that will work for Avangrid Renewables
Job Posting End Date:
March202025Required Experience:
IC
Employment Type
Full Time
