Unclassified
posted 3 months ago
The Senior SQL Server DBA position at DMS Vision Inc. is a critical role designed for an experienced database administrator with a strong background in SQL Server and SSIS. This position is fully remote and is structured as a 6-month contract, allowing for flexibility while ensuring that the right candidate can contribute effectively to the team. The primary responsibilities include designing and implementing complex database structures, including databases, tables, stored procedures, views, and triggers. The DBA will also be tasked with developing ETL (Extract, Transform, Load) solutions, which are essential for data integration and management within the organization. In addition to design and development, the Senior SQL Server DBA will work closely with application development teams to optimize application performance. This involves employing various techniques for database performance optimization, such as indexing, query optimization, and effective database design. The role also includes participating in High Availability and Disaster Recovery tests to ensure that critical systems are resilient and can recover from potential failures. Monitoring database performance is a key aspect of this role, requiring proactive capacity planning and resource consumption management. The DBA will provide day-to-day support for databases and database applications, ensuring that they operate smoothly and efficiently. Regular upgrades and patches to the DBMS will also be part of the responsibilities, along with ensuring that all databases and database objects are backed up according to business requirements, with documented recovery procedures in place.