Senior Sql Database Administrator

SGS Technologie; Tallahassee (FL); On-site; USD 65,000 - 70,000; Full time

Job summary

A leading technology company is seeking a SQL Database Administrator/Architect for a 12+ month contract in Tallahassee, FL. The role requires advanced SQL Server skills and involves responsibilities such as implementation, maintenance, and optimization of database systems. Ideal candidates will have experience in security management, troubleshooting, and performance tuning. This is an excellent opportunity to join a dynamic team and contribute to critical database projects.

Qualifications

• Advanced experience with SQL Server from 2012 to 2017.
• Expertise in database security and user permissions management.

Responsibilities

• Implementing backup strategies and disaster recovery procedures.
• Managing database security, user permissions, and access controls.
• Performing routine maintenance tasks on SQL Server.

Skills

SQL Server Experience

Performance Optimization & Tuning

Security

Troubleshooting

Data Conversion & Cleansing

Tools

Microsoft Clustering Services

DTS/SSIS Packages

Job description

Get AI-powered advice on this job and more exclusive features.

Direct message the job poster from SGS Technologie

Role: SQL Database Administrator / Architect (Advanced)

Location: Tallahassee, FL (We are looking for candidates who are currently located in Florida for this role).

Duration: 12+ months

Professional Requirements:

The database administrator consultant is required to have professional working experience at an advance level to carry out the following job duties.

• SQL Server Experience: Working knowledge of Microsoft SQL Server from version 2012 to 2017.
• Microsoft Clustering Services: Implementation and management of clustering services.
• Installation & Configuration: Installing and configuring SQL Server instances.
• Operating System & Interoperability: Ensuring the smooth integration of SQL Server with the operating system and other applications.
• Regular Maintenance: Performing routine maintenance tasks on SQL Server.
• Backups & Disaster Recovery: Implementing backup strategies and disaster recovery procedures.
• Troubleshooting: Identifying and resolving performance or operational issues.
• Security: Managing database security, user permissions, and access controls.
• Performance Optimization & Tuning: Analysing and optimizing SQL queries and server performance.
• Database & Objects Administration: Administering databases and objects, including tables, indexes, views, and stored procedures.
• Scheduled Jobs Management: Managing and troubleshooting SQL Server Agent jobs and tasks.
• Triggers: Creating and maintaining triggers within the database.
• Data Transfers & Replication: Managing data transfer, replication processes, and ensuring smooth data synchronization.
• Design & Development: Designing and developing database schemas, including creating tables, relationships, and views.
• Stored Procedures Review: Writing, reviewing, and optimizing stored procedures for efficiency.
• Table Creation on Production Servers: Creating and managing tables on production servers.
• DTS/SSIS Packages: Creating and managing Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) packages.
• Field Additions: Adding fields to existing tables on production servers.
• Bulk Copy Operations: Managing bulk data load processes.
• Data Conversion & Cleansing: Handling data conversion and performing data cleansing tasks.
• Software Upgrades: Planning and executing software upgrades for SQL Server instances.
• Data Archiving: Implementing archiving strategies for data retention and compliance.
• Data Dictionary Creation: Creating and maintaining a data dictionary for all database objects.
• Data Model Creation & Modification: Designing and modifying data models to ensure data integrity.
• Documentation: Creating and maintaining detailed documentation for database systems and processes.
• Transactional Replication: Configuring and managing transactional replication in SQL Server.
• Source Control Management: Managing source control using SQL Prompt and SQL Compare tools.
• Proactive Monitoring: Implementing proactive monitoring to ensure database systems run securely with minimal downtime.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Contract

Job function

• Job function

  Information Technology

• Industries

  IT Services and IT Consulting

Referrals increase your chances of interviewing at SGS Technologie by 2x

Get notified about new SQL Database Administrator jobs in Tallahassee, FL.

Microsoft SQL Server Database Administrator

Tallahassee, FL $65,000.00-$70,000.00 1 month ago

Tallahassee, FL $105,100.00-$192,700.00 4 days ago

Tallahassee, FL $80,000.00-$120,000.00 1 day ago

LLM Data Engineer | United States | Fully Remote

Tallahassee, FL $85,000.00-$90,000.00 3 months ago

Tallahassee Metropolitan Area $55.00-$60.00 3 days ago

Staff Data Engineer - Observability Data Lake

Enterprise Systems Developer - Workday (Remote)

Staff Capacity Planning Developer & Modeler (ClickHouse)

SAP ABAP Programmer With BW/BI Experience

Tallahassee, FL $130,000.00-$160,000.00 1 day ago

Tallahassee, FL $100,000.00-$150,000.00 1 day ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.