ISD Engineer III (SQL Server Database Administrator)

Company: Navy Federal Credit Union
Location: Vienna
Posted on: May 3, 2024

Job Description:

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)
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.
--- Setup High-Availability and Disaster Recovery
--- Plan and test high availability and disaster recovery
--- 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.
--- Setup SQL agent jobs, elastic jobs, and runbook automation
--- 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
--- 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; Tuning ETL Jobs - SSIS & Azure Data Factory
--- Design and create databases to support development initiatives.
Bachelor's Degree or related working experience
--- 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.
--- Hours: Monday - Friday, 8:00AM - 4:30PM
And we're looking for team members who are passionate about our mission-making a difference in military members' and their families' lives. 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
--- 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. 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, Potomac , ISD Engineer III (SQL Server Database Administrator), IT / Software / Systems , Vienna, Maryland