Come join our team! At Unlimited Technology, we are committed to our company's core values of Passion, Collaboration, Innovation and Adaptability. With offices throughout the United States, we are a premier cyber and physical security specialty contractor, and we are growing at a rapid pace. We have a wide range of talented and experienced individuals that deliver cutting edge technology solutions to meet our customers’ ever-changing needs. We secure the facilities and networks of the world’s leading brands and critical infrastructure and are recognized leaders in the physical and IT security, cyber, and managed services industries. UT offers a rewarding career, great benefits, and the chance to learn and work with ground-breaking technology and premier clients. SQL Database Administrator (DBA) Responsibilities: Works closely with our analysts, systems administrators, and designers to support implementation, configuration, maintenance, troubleshooting, and optimization of Microsoft SQL Servers. **SQL DBA Duties:** + Responsible for creation and ongoing maintenance of functional and relational Database Diagrams for all Network Services Company SQL Databases. Keep diagrams/documentation current and establish effective vehicles to publish the documentation to Applications Staff and others for use in report development and ASD Operations Projects. + Ability to write and troubleshoot complex Stored Procedures, ANSI and T-SQL queries and scripts, and document processes and procedures. + Experience implementing operational automation. + Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems. + Configure database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. + Update, backup, maintain & troubleshoot databases. Perform troubleshooting, resolution and root cause analysis for database and application specific incidents. + Programing in SQL. Write and optimize SQL statements. + Work as a subject matter expert on database technologies, reviewing changes, security & operations procedures to maximize uptime & reduce time to recover. + Perform all common periodic Database Administration (DBA) tasks, including managing database backups and recovery, managing database users and security, Database Server Administration, Event and System Monitoring, etc. + Design database indexing schemes and perform optimal DB tuning + Ability to detect and troubleshoot SQL server related CPU, Memory, I/0, disk space and other resource contention. + Periodic review of all database Maintenance, Backup, and Optimization plans. + Recommend improvements to support use of database best practices, more efficient processing, improved system uptime, and to support the growth of the business. + Periodic review of all current SQL servers from a security (Windows and SQL) standpoint. + Review industry best practices and make periodic recommendations for Database security and Windows server related security improvements. + Ability to export and import data from/to various formats like delimited raw/text file, MS-Excel, XML, SQL Server, MS-Access, etc. + Ability to transfer data between various servers and/or data sources. + Ability to restore databases and individual tables upon request. + Provide leadership, architectural recommendations and implementation plans for potential long-term database scalability, performance improvements, and support for a hybrid infrastructure. **SQL DBA Skills and Qualifications:** + Bachelor’s degree in IT or related field or equivalent work experience. + 5+ years MS SQL Server Administration experience required. + Experience with Failover Clustering and Always on Availability Groups. + Experience with Performance Tuning and Optimization + Experience with backups, restores and recovery models. + Experience working with Windows Server, including Active Directory. + Experience writing SQL queries, analyzing query performance using query plans and tuning query performance. + Experience with C#, Visual Basic or Visual Studio Preferred. + Critical thinking skills and ability to adapt to rapid project changes + Provide on call support for critical production systems. + Share technical expertise, providing technical mentorship and cross-training to other peers and team members. + Strong organizational and communication skills. + Ability to be onsite 5 days a week in Rochester, NY with no relocation offered. Pay Range $95,000—$110,000 USD **Benefits** + Health, dental, and vision coverage + Life insurance + 401 (k) w/company match 100% up to 3% and an additional 50% match of 2% + Paid time off + 11 Paid Holidays **_We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, creed, sex, age, national origin, disability, Veteran status, or any other category protected by federal, state, or local laws._** Integrated Security Technologies, Inc. does not discriminate on the basis of race, sex, color, religion, age, national origin, marital status, disability, veteran status, genetic information, sexual orientation, gender identity or any other reason prohibited by law in provision of employment opportunities and benefits.