Job Description
● Assist software developers with database operations including the development of complex SQL, tuning of DML, and the creation of stored procedures.
● Install and configure new Microsoft SQL Server instances, including AlwaysOn availability groups and failover clustering.
● Troubleshoot performance issues (database settings, optimizing queries, altering indexes, ETL development, etc.).
● Monitor and maintain database systems and troubleshoot problems that may arise.
● Create users and assign database permissions.
● Index management to improve data retrieval performance.
● Schedule and monitor daily jobs relating to data transfers, backup, and recovery, transaction log dumps.