ISD Engineer III (SQL Server Database Administrator)
Company: Navy Federal Credit Union
Location: Vienna
Posted on: May 1, 2024
|
|
Job Description:
OverviewSQL 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:30PMLocation: 820 Follin
Lane, Vienna, VA 22180 - 5550 Heritage Oaks Dr. Pensacola, FL 32526
- 141 Security Dr. Winchester, VA 22602Job 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 UsYou 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 ServicesEqual 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/DisabilityDisclaimers: 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 positionBank 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, Frederick , ISD Engineer III (SQL Server Database Administrator), Engineering , Vienna, Maryland
Click
here to apply!
|