SQL Server Database Administrator

Infinite Computer Solutions (ICS)

United States

2 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

8 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Profiling Databases Data Infrastructure Data Integrity Data Retrieval Data Security IBM DB2 Query Languages Database Security Disaster Recovery File Systems Monitoring of Systems

+18 more

Internet Information Services (IIS) Python (Programming Language) Microsoft SQL Server Windows Servers Performance Tuning Windows PowerShell Query Optimization SQL Databases Transaction Processing (Computing) Scripting System Availability Database Performance Information Technology Performance Monitor SQL Server Management Studio (SSMS) Database Backup Splunk Dynatrace

Job description

SQL Server Management: Install, configure, and administer Microsoft SQL Server databases, ensuring optimal performance, scalability, and high availability.
Query Optimization and Tuning: Write and optimize SQL queries to improve database performance, focusing on efficient data retrieval and transaction processing.
Database Backup and Recovery: Manage backup, restore, and recovery plans to ensure data protection and disaster recovery.
Security Management: Implement and maintain database security protocols, access controls, and encryption, following best practices and compliance standards.
Automation and Scripting: Develop PowerShell and Python scripts for automating routine database tasks, file processing, and report generation to enhance productivity.
Performance Monitoring: Use monitoring tools like Splunk, Dynatrace, and SQL Server Profiler to track database health, detect performance issues, and conduct root cause analysis.
Technical Product Implementations: Support and perform SQL DBA and Windows Server administration for technical product deployments, ensuring smooth integration with existing systems.
Cross-Platform Database Support: Provide support for IBM Db2 and other database platforms as needed, ensuring a cohesive data infrastructure.
Collaboration with Cross-Functional Teams: Work closely with infrastructure, development, and business teams to align database solutions with organizational goals and support stability.

Requirements

The SQL Server Database Administrator (DBA) is responsible for the configuration, maintenance, and troubleshooting of Microsoft SQL Server environments. This role supports data integrity, performance optimization, automation, and secure data transfer processes within SQL and Windows Server platforms. Experience with PowerShell and Python scripting, as well as familiarity with IIS, automated file processing, and connectivity troubleshooting, is required. The ideal candidate has a proactive approach to database administration with skills in monitoring tools such as Splunk and Dynatrace, and experience in the financial services industry is a plus., * Bachelor s Degree in Computer Science, Information Technology, or a related field, or equivalent experience.

8+ years of experience as a SQL Server Database Administrator with a focus on performance tuning, automation, and data security.
Proficiency in SQL Query Language, PowerShell scripting, and database performance monitoring.
Knowledge of Windows Server and basic network connectivity troubleshooting.
Experience in automation using PowerShell or Python.
Experience with monitoring tools like Splunk and Dynatrace is preferred.
Previous experience in the banking or financial services industry is a plus, especially with Fiserv Premier products.