We are seeking a talented and seasoned Database Administrator to supervise our expansive database infrastructure. This role will oversee the management of over 100 Microsoft SQL databases supporting over 50 applications throughout the enterprise, drive the progress of our Master Data Management (MDM) project, and provide supervisory direction to data analytics endeavors citywide. The ideal candidate will possess profound expertise in database management, leadership qualities, and a vision to optimize and steer data analytics operations.
JOB Responsibilities:
* Plan and Manage installation of new instances of SQL Server as required.
* Plan and manage upgrades of existing instances of SQL Server to insure all instances are operating on supported versions of the software at all times.
* Design underlying database file structure and manage to optimize performance on an on-going basis.
* Design and implement database backup strategy.
* Design and implement a high availability database architecture including both Always-On and Read-Scale availability groups.
* Monitor database performance on an ongoing basis.
* Manage installation, configuration and upgrade of database performance monitoring software.
* Develop a deep understanding of Asembia’s business systems through participation in application design sessions and translate business requirements into physical data models as required.
* Monitor database performance on an on-going basis.
* Serve as technical advisor to Application Developers on SQL best practices and performance tuning.
* Help troubleshoot application issues related to performance, data accuracy or other symptoms that where the database my have play a part.
JOB Requirements:
* Bachelor's Degree in Computer Science, Information Systems, or other related field.
* 2+ years of related experience.
* Must possess excellent interpersonal and written/oral communication skills.
* The ability to interact with staff at all levels.
* Strong knowledge of personal computers and software, specifically Microsoft Office.
* Thorough knowledge of structured query language, Microsoft SQL Server, Reporting Services, transactional replication, and Always on Availability Groups.
* Strong knowledge of transactional replication and publisher/subscriber configurations.
* Must be US Residential/Freelancer ONLY