Job Description
The SQL Server DBA will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our enterprise applications. This is a "hands-on" position requiring solid technical skills, as well as excellent interpersonal and communication skills.
* Installation, Administration and Maintenance of SQL Server Instances
* Create Users and assign permissions based on the level of database access the user would need
* Support the client's data engineering project
* Troubleshoot various problems that arise in the day-to-day operations and fix the issues
* Monitoring and Performance Tuning; Physical Server Level, Database level (Database settings and options) and query tuning to include index optimizations
* Database growth vs disk space available, audits, resource monitoring (I/O bottlenecks, memory pressure, CPU use)
* Manage Maintenance Plans
* Monitor backups to ensure they are being performed regularly
* From time to time recover the databases to a specific point of time, as per the requests
Performs highly responsible professional work designing and administering the database resources for the organization and for providing technical support for efficient use throughout the organization. Designs the overall database architecture to maximize performance, reliability, and recoverability. Administers and maintains the organization's current database resources; performs troubleshooting for SQL server databases; and monitors and optimizes server performance. Ensures data availability, security, and integrity for all corporate database applications. Provides technical and customer support in various transit-related and administrative mission-critical business applications. Installs and upgrades the database server and application tools. Allocates system storage and plans for future storage requirements for the database system. Modifies the database structure, as necessary, from information given by application developers/vendors. Enrolls users and maintains system security. Ensures compliance with database vendor license agreement. Controls and monitors access to the database. Contributes to planning of backup and recovery of database information. Maintains archived data. Backs up and restores databases. Contacts database vendors for technical support. Responds to escalations from IT Team. Provides availability to 24/7 on-call rotation as referenced in the IT Department on-call procedure. May be required to be available through a mobile device via voice and/or data during and outside of normal working hours, at the manager's discretion, and must respond within a reasonable timeframe
Required Skills & Experience
* Knowledge of; data modeling and database administration (Microsoft SQL server)
* 10+ years Microsoft SQL
* Azure
* Automation
* Disaster Recovery
* Microsoft Azure experience
* SSIS / SSAS / SSRS experience
* Data Warehousing experience
* Knowledge of database theory and database design
* General understanding of distributed computing architectures e.g., Client/Server, Internet/Intranet Enterprise.
* General understanding of routine maintenance, recovery, and handling failover (includes clustering) of a Database.
* Knowledge of Microsoft SharePoint
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.