SQL Server DBA
Utilities/Energy company
Utilities/Energy company
Jacksonville, FL 32256
W-2 onlyPermanent Position10144 views
Jacksonville, FL 32256
Permanent Position
Questions?
Click to chat now!
This posting has been closed

JOB PURPOSE

Database Administrator and Application Support role specialized in Microsoft SQL Server over Dynamics 365, Azure PaaS and IaaS, with a focus on performing duties in the full development and operation lifecycle of databases and database-based products and services, including administration, development, testing, production support and onboarding bulk data uploads.

RESULT AREAS & RESPONSIBILITIES

DRBCP & Service Uptime – 10%

  • Ensure all database servers are backed up in a way that meets the Recovery Point Objectives (RPO)
  • Test backups to ensure we can meet the Recovery Time Objectives (RTO)
  • Troubleshoot DB Servers & Service outages as they occur, including after-hours and weekends and propose improvements for a more robust service based on root cause analysis
  • Configure DB Services monitoring and alerting utilities and conduct periodic performance and resource usage trend analysis

Documentation – 10%

  • Undertake architectural design & Process maps for existing and new databases
  • Document DB related technical issues and resolutions for future reference

Administration – 30%

  • Review and make recommendations for tuning existing environments
  • Conduct capacity planning on existing and new services, manage scaling out/up process for striking a balance between performance and costs, implement HA with the relevant tools and techniques
  • Design, create and implement new database environments including HA and replication setups against a set of company standards and principles
  • Implement governance and database change management
  • Review and deploy database change scripts provided by third party vendors
  • Create, maintain and update maintenance scripts for databases (e.g. indexes, integrity checks)

Product Support & Implementation – 20%

  • Develop scripts and support bulk uploads of data into DB based on various input files
  • Product support for Danfoss and Emerson BMS (Building management Software)
  • Configure services and ETL to extract data for reporting team
  • Rostered on-call troubleshooting

Development & Coaching – 30%

  • Ensure that new database code meets company standards for readability, reliability, and performance
  • Periodically give developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each
  • Design indexes for existing applications, choosing when to add or remove indexes
  • Assist developers improve the performance of queries by modifying statement or indexes
  • Conduct SQL Server & PostgreSQL lunch-and-learn sessions for application developers
  • Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc.)

QUALIFICATIONS & EXPERIENCE

EDUCATION:

  • Bachelor’s degree in Computer Science or a related field
  • Industry certifications in Microsoft SQL Server, PostgreSQL, and .NET

EXPERIENCE:

  • Experience with SQL Server development, administration, operation (HA and DR setups) and maintenance in Azure IaaS and PaaS
  • Experience in monitoring and troubleshooting performance or operational issues in SQL Server& PostgreSQL (ideally within App Insights)
  • Experience with DBA tools from Red Gate suite or community based (Brent Ozar Blitz suite, Ola Hallengren scripts) in order diagnose server reliability and performance issues or schedule maintenance works
  • Proficient T-SQL queries, DDL and DML
  • Database architecture design, normalization, data types optimization
  • App usage profiling on database
  • On-call troubleshooting experience with at least one production SQL Server for a year and experience with 5 TB+ database sizes
  • Exposure to Dynamics 365, Snowflake on Azure, Matillion, Power BI, NoSQL, IoT data handling - preferred

CORE COMPETENCIES

  • Leadership
  • Results-Driven
  • Builds Organizational Talent
  • Financial Business Acumen
  • Business Judgment
Skills
Skill Proficiency Years Experience Percent Used
DBA
3 - 6100%
SQL Server
3 - 6100%
.NET
Any75%
Azure App Insights
Any75%
Data Replication
Any75%
Database Backups
Any75%
Database Design
Any75%
IaaS
Any75%
MongoDB
Any75%
MS Azure
1 - 375%
PaaS
Any75%
PostgreSQL
Any75%
SQL
Any75%
T-SQL
Any75%
MS Dynamics 365
Any50%
Application Support
Any25%
Capacity Planning
Any25%
Database Maintenance
Any25%
ETL
Any25%
HA
Any25%
MS Power BI
Any25%
Production Support
Any25%
Snowflake
Any25%
Stored Procedure
Any25%