Volitiion IIT
Location
Maryland | United States
Job description
Location: Vienna, VA/Pensacola , FL- remote position but the candidate needs to be local to either for these 2 locations
Location: Remote but must be local to Pensacola or Northern Virginia/HQ locations.
Senior Azure & On Prem MS SQL 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)
Essential Functions
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 de
4 Reasons to Join Volitiion IIT, Inc.:
1. Our Commitment to You - We offer competitive pay, multi-year projects, and a list of exciting clients.
2. Work-Life Balance - We work hard; we work smart and have quality time for family and "life."
3. Our Mantra - We treat our consultants the way we want to be treated: with integrity, professionalism, and trust.
4. Career Development - We help you meet your career goals and continuously support your efforts to build your skillset.
Check out our Referral Program!
Volitiion IIT Inc will pay you up to $1000 for every qualified professional that you refer and we place. If you see a position posted by Volitiion IIT Inc. and know the perfect person for the job, please send us your referral.
Volitiion IIT Inc. is an Equal Opportunity/Affirmative Action Employer.
Job tags
Salary
