Review Vacancy
AgencyDASNY - Dormitory Authority of the State of New York
TitleSr. SQL Database Administrator
Occupational CategoryI.T. Engineering, Sciences
Salary RangeFrom $88113 to $88113 Annually
Minimum Qualifications printer, copier, scanner, electronic stapler/hole punch/date stamp, shredder.
Minimum Qualifications
• High School diploma or equivalent combined with other forms of related education, training and experience may be considered.
Or:
• Associate’s degree in Computer Science or related field plus seven years of SQL Server installation & configuration, database administration, performance tuning SQL queries, data extract & interface development, data modeling, and production support.
Or:
• Bachelor’s degree in Computer Science or related field plus five years of SQL Server installation & configuration, database administration, performance tuning SQL queries, data extract & interface development, data modeling, and production support.
Extensive hands-on experience in SQL Server configuration, database administration, performance tuning, data modeling, and SQL application development.
• SQL Server - Installation, Configuration, Security Standards, Performance Monitoring.
• SQL Server Cluster setup & management.
• Data Model Design and SQL Development.
• Development of data interfaces and extracts.
• Migration of data from multiple legacy applications to a new system.
• Setup of nightly data-transfer job.
?
Preferred Qualifications
Hands-on experience with Microsoft PowerShell scripting.
Experience with supporting SQL databases in Azure.
Essential Skills
• Ability to thrive in a team environment.
• Demonstrated ability to work with users and other developers to analyze data requirements.
• Demonstrated analytical, conceptual and problem solving skills.
• Demonstrated ability to work independently and exercise sound judgment.
• Demonstrated organizational skills and ability to prioritize.
• Strong interpersonal skills.
• Excellent oral and written communications skills.
• Proficiency in Microsoft Office applications.
Duties Description Primary Purpose
The Senior Database Administrator (SDBA) installs, configures, maintains, and manages performance of SQL servers. The SDBA designs and develops SQL applications, and performs data migration to new systems.
Essential Functions
• Install, configure, maintain, and manage performance of SQL Servers that support business applications. Monitor the health of SQL servers.
• Administer SQL Servers in Development, Test, Production, and Disaster Recovery (DR) environments.
• Create and administer SQL databases set up in cloud environments such as Azure.
• Setup SQL Server clusters to provide redundancy.
• Assist in managing database backups to support Disaster Recovery (DR) functions. Participate in DR testing.
• Develop or assist in the definition of security requirements of databases, entities, and data elements.
• Assist with the analysis and implementation of NY State Information Security Standards.
• Administer SQL Server and database access.
• Upgrade SQL Servers and assist with transitioning applications to a newer version of the server.
• Act as a consultant to other DASNY business units, seeking out areas to improve efficiencies.
• Work with Application Developers and Business Users to analyze business processes and determine data requirements.
• Collaborate with Application Developers to develop and support complex data models.
• Develop or assist with SQL application development. Support database requirements of custom applications. Assist developers with performance tuning complex SQL queries.
• Design and build data interfaces between systems and external entities such as banking, payroll and other financial systems.
• Setup and monitor nightly batch jobs that transfer data between systems or to external entities.
• Work with vendors and consultants to map, migrate, and convert data to new packaged applications.
• Assist with development of database standards such as naming conventions, SQL development best-practices, and performance standards.
• Troubleshoot application and data issues in production.
• Assist with reports and dashboard development.
• Maintain current knowledge of new products and trends in database management.
• Independently build strong relationships with external partners and trustees, including vendors, clients, and other state agencies.
?
Other Duties and Responsibilities
• Assist with the development of RFPs and participate in the evaluation process (of software products and consulting services).
• Ensure compliance with DASNY and NYS policies.
• May train and evaluate employees.
• Assist with the documentation and implementation of procedures.
• Assist with internal controls implementation, review, and testing.
• Undertake special assignments as directed.
• Must maintain regular attendance in accordance with DASNY attendance and leave policies.
• Must adhere to the NYS Information Security Policy Standards established and issued by the NYS Office of Information Technology Services. (Standards can be found on the Intranet).
Additional Comments Supervision
Supervision of employees may be required.
Physical/Mental/Visual Demands
Occasional travel is required using public transportation, DASNY vehicle, rental vehicle or personal vehicle. This travel may include overnight stays at public accommodations and related establishments. Requires complex and time-pressured decision-making. Overtime or extended work hours may be required.
Work Environment
Standard office environment, including the use of one or more of the following: PC, telephone, fax machine, printer, copier, scanner, electronic stapler/hole punch/date stamp, shredder.
DASNY is an Equal Employment Opportunity employer committed to excellence and diversity.
All qualified candidates are encouraged to apply.
Some positions may require additional credentials or a background check to verify your identity.