Minimum Qualifications
Minimum of 4 to 5 years as a database administrator with three plus years SQL Server 2016 and newer or equivalent combination of experience and education including college courses such as MIS, Computer Science, or related field. Experience must include eight years of SQL OLTP or Data Warehouse development experience including T-SQL, MDX, SSIS, SSRS, and SSAS, developing and delivering database solutions in an enterprise environment. Certifications in MCTS (Microsoft Certified Technology Specialist), MCSA (Microsoft Certified Solutions Associate) or MCSE (Microsoft Certified Solutions Expert) in SQL Server / Data Platform is a plus. Experience working with Azure SQL databases, managed instances, stretched databases, data lakes, and log analytics is a plus. Experience working with AWS QLDB is a plus. The ideal candidate will have deep experience in database administration involving management of multiple SQL databases in a highly dynamic environment.
Knowledge, Skills & Abilities
- Strong experience with performance tuning on MS SQL Server, experience with data integrity, data retention, data analysis and data input/output processing and improving SQL code performance efficiency.
- Knowledge of SQL Utilities (BCP, DTS, SSIS-2016+, SSAS, Power BI, etc.).
- Experience supporting database access from large scale .NET based windows, web, web services and RESTful API applications.
- Experience with creation and implementation of fully functional SQL Server databases, ability to maintain multiple development and QA SQL Server environments.
- Experience with Replication, Clustering, Always On and other HA architectures.
- Advanced knowledge of T-SQL and ability to write stored procedures, UDF’s and triggers, debugging and performance tuning stored procedures, index analysis; various monitoring and tuning tools such as Profiler, Spotlight, advanced installation and configuration procedures and data normalization.
- Experience with Version Control Systems such as Microsoft Team Foundation Server or other comparable systems.
- Proven competence with partitioning, advanced queuing, cursors, etc.
- Must have basic working knowledge of hardware, networking and SQL Server connectivity and the tools needed to troubleshoot and diagnose issues with them.
- Team player with excellent verbal and written communication skills.
- Ability to take initiative, exercise good judgment and exhibit business savvy orientation.
- Excellent conceptual, analytical, and judgment abilities.
Notes:
- Possibility if budget is approved to do CTH
- Fully remote- est time zone or Central
- SQL DBA
- On prim moving to cloud
- SSRS/ SSIS a plus
- Culture- strict deadlines, busy work load
- Must have strong internal communication
- Flexible with if needed working late
- Avg is 40 hour work week
- Nonprofit company
- Currently a team of 3 working with two other DBAs