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 - 6 | 100% | |
SQL Server | 3 - 6 | 100% | |
.NET | Any | 75% | |
Azure App Insights | Any | 75% | |
Data Replication | Any | 75% | |
Database Backups | Any | 75% | |
Database Design | Any | 75% | |
IaaS | Any | 75% | |
MongoDB | Any | 75% | |
MS Azure | 1 - 3 | 75% | |
PaaS | Any | 75% | |
PostgreSQL | Any | 75% | |
SQL | Any | 75% | |
T-SQL | Any | 75% | |
MS Dynamics 365 | Any | 50% | |
Application Support | Any | 25% | |
Capacity Planning | Any | 25% | |
Database Maintenance | Any | 25% | |
ETL | Any | 25% | |
HA | Any | 25% | |
MS Power BI | Any | 25% | |
Production Support | Any | 25% | |
Snowflake | Any | 25% | |
Stored Procedure | Any | 25% |