Review Vacancy
Date Posted: 09/20/19
Applications Due: 10/04/19
Vacancy ID: 74279
Position Information
NY HELPNo
AgencyDASNY - Dormitory Authority of the State of New York
TitleSr. SQL Database Administrator
Occupational CategoryI.T. Engineering, Sciences
Salary GradeNS
Bargaining UnitNone listed
Salary RangeFrom $88113 to $88113 Annually
Employment Type Full-Time
Appointment Type Permanent
Jurisdictional Class Unclassified Service
Travel Percentage 15%
Schedule
Workweek Mon-Fri
Hours Per Week 37.5
Workday
From 8 AM
To 4 PM
Flextime allowed? No
Mandatory overtime? Yes
Compressed workweek allowed? No
Telecommuting allowed? No
Location
County Albany
Street Address 515 Broadway
City Albany
StateNY
Zip Code12207
Job Specifics
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.
Contact Information
Name Nicholas Ouellette
Telephone
Fax 518-257-3550
Email Address JobOpps3@dasny.org
Address
Street 515 Broadway
City Albany
State NY
Zip Code 12207
Notes on ApplyingTo apply, please copy and paste the following link in your browser:
https://dasny.clearcompany.com/careers/jobs/5d99fb4d-3b74-1570-eeea-57e30ed63c07/apply?source=1140015-CS-20928
FAQs • Workers with Disabilities (55b/c) • Civil Service Exams
State Agencies: Department of Civil Service • Office of the State Comptroller
OER Link: Employee Unions and Bargaining Units
Exam announcements • General Information about NYS Government
© 2024 NYS Department of Civil Service
StateJobsNY ℠ 2024 NYS Department of Civil Service
Accuracy • Privacy • Accessibility • Contact