ISD Engineer III (SQL Server Database Administrator)
Company: Navy Federal Credit Union
Location: Vienna
Posted on: May 9, 2024
|
|
Job Description:
Overview
SQL Server Database Administrator will be responsible for the
management of production and non- production databases; database
maintenance activities; troubleshooting database-related issues;
monitoring of database capacity and performance; installation,
administration, and configuration of database
server/instances/databases; installation and configuration of SSRS,
and Power Bi RS; Support release/code deployment activities (SSIS
Packages, SSRS reports, SQL objects etc)
Responsibilities
--- Conduct the following for Azure SQL/Azure SQL MI/SQL on Azure
VM, On Prem SQL Server, SSRS, Power Bi RS, SSIS, Azure Synapse and
other related products as applicable and necessary.
--- Install/Configure/Setup/Administer and Maintain production and
non-production environments.
--- Setup High-Availability and Disaster Recovery
--- Plan and test high availability and disaster recovery
--- Create Users and assign/manage permissions based on the level
of access the user would need; ensure robust and full proof
security of assets.
--- Resolve database integrity, performance, blocking,
connectivity, and replication issues.
--- Detect and resolve database-related CPU, memory, I/O, disk
space and other contention issues.
--- Perform and manage Database backup/recovery/restore and
capacity monitoring.
--- Synapse workload management and optimization
--- Setup SQL agent jobs, elastic jobs, and runbook automation
--- Identify and setup alerts and logging in Azure.
--- Maintain databases - Statistics, Indexes, fragmentation.
--- Upgrade and maintain SQL Server and related software (apply
patches and updates when necessary)
--- Coordinate removal and/or archiving of data that is no longer
required to be available in the production databases.
--- Deploy and configure SSIS packages and SSRS and Power Bi RS
Reports. Troubleshoot issues with SSRS, Power Bi RS, and SSIS.
--- Support release/code deployment activities
--- Provide 24x7 support as necessary.
--- Implement operational automation using scripts.
--- Conduct Performance tuning and optimization (Stored procedures,
Views, Functions, Queries, database) - In-depth SQL database
advanced performance tuning experience - Stored Procedures, Views,
Functions; skilled in analyzing and assessing query execution plans
and DMVs; expertise in assessing and implementing indexes and
partitioning; Tuning ETL Jobs - SSIS & Azure Data Factory
--- Design and create databases to support development
initiatives.
Qualifications
--- Bachelor's Degree or related working experience
--- Experience in HA/Failover technologies
--- Experience in log shipping and DR Environments
--- Experience with DataSync in Azure and other technologies used
in replicating data.
--- Strong Experience in Performance Tuning and Optimization
(PTO)
--- Experience with SQL Server versions 2016 to 2022
--- Experience running and troubleshooting SSIS packages.
--- Experience troubleshooting performance issues in the SQL Server
environment.
--- Good verbal and written communication are a must have.
Hours: Monday - Friday, 8:00AM - 4:30PM
Location: 820 Follin Lane, Vienna, VA 22180 - 5550 Heritage Oaks
Dr. Pensacola, FL 32526 - 141 Security Dr. Winchester, VA 22602
Job postings are subject to close early or extend out longer than
the anticipated closing date at the hiring team's discretion based
on qualified applicant volume.
About Us
You have goals, dreams, hobbies, and things you're passionate
about-what's important to you is important to us. We're looking for
people who not only want to do meaningful, challenging work, keep
their skills sharp and move ahead, but who also take time for the
things that matter to them-friends, family, and passions. And we're
looking for team members who are passionate about our
mission-making a difference in military members' and their
families' lives. Together, we can make it happen. Don't take our
word for it:
--- Military Times 2022 Best for Vets Employers
--- WayUp Top 100 Internship Programs
--- Forbes - 2022 The Best Employers for New Grads
--- Fortune Best Workplaces for Women
--- Fortune 100 Best Companies to Work For -
--- Computerworld - Best Places to Work in IT
--- Ripplematch Campus Forward Award - Excellence in Early Career
Hiring
--- Fortune Best Place to Work for Financial and Insurance
Services
Equal Employment Opportunity: Navy Federal values, celebrates, and
enacts diversity in the workplace. Navy Federal takes affirmative
action to employ and advance in employment qualified individuals
with disabilities, disabled veterans, Armed Forces service medal
veterans, recently separated veterans, and other protected
veterans. EOE/AA/M/F/Veteran/Disability
EOE/AA/M/F/Veteran/Disability
Disclaimers: Navy Federal reserves the right to fill this role at a
higher/lower grade level based on business need. An assessment may
be required to compete for this position. Job postings are subject
to close early or extend out longer than the anticipated closing
date at the hiring team's discretion based on qualified applicant
volume. Navy Federal Credit Union assesses market data to establish
salary ranges that enable us to remain competitive. You are paid
within the salary range, based on your experience, location and
market position
Bank Secrecy Act: Remains cognizant of and adheres to Navy Federal
policies and procedures, and regulations pertaining to the Bank
Secrecy Act.
Keywords: Navy Federal Credit Union, Burke , ISD Engineer III (SQL Server Database Administrator), Engineering , Vienna, Virginia
Click
here to apply!
|