Review Vacancy
AgencyFinancial Services, Department of
TitleInformation Technology Specialist 3 (Database)
Occupational CategoryI.T. Engineering, Sciences
Bargaining UnitPS&T - Professional, Scientific, and Technical (PEF)
Salary RangeFrom $79325 to $100342 Annually
Minimum Qualifications Appointment method:
List Appointment: Candidates must be reachable on the Civil Service eligible list for 26-378 or 38-711.
Transfer: Candidates must have one year of permanent competitive service in a title eligible for transfer via Sections 70.1 or 52.6 of the Civil Service Law. Information regarding transfer eligibility may be available on the Civil Service Career Mobility Office website at http://careermobilityoffice.cs.ny.gov/cmo/.
Please Note that under Civil Service Law, an employee cannot have two consecutive upward 70.1 or 52.6 transfers without an intervening eligible list appointment if such transfers would exceed two salary grades.
Duties Description The New York Department of Financial Services seeks to build an equitable, more transparent and resilient financial system that benefits New Yorkers and supports business. Through engagement, data-driven regulation, and operational excellence, DFS is responsible for empowering consumers and protecting them from financial harm; ensuring the health and stability of the financial entities we regulate; and driving economic growth through responsible innovation.
DFS is seeking candidates to fill the position of Information Technology Specialist 3 (Database), SG-23. Duties include, but are not limited to, the following:
• Designs, develops and integrate highly complex Oracle database systems for internal and external users/clients;
• Installs, configures, patch and upgrade Oracle database management system (DBMS) and corresponding application tools;
• Monitors and enhances the capacity and performance of the database, and resolve Oracle database performance, capacity, replication, and other distributed data issues;
• Administers, maintains, develops and implements policies and procedures for ensuring the security and integrity of DFS's Oracle database;
• Implements both database and OS- level security policies for data protection by using Oracle security features such as Oracle Wallet and Transparent Data Encryption;
• Performs SQL tuning and SQL optimization by utilizing Oracle built in features, such as optimizer statistics, EXPLAIN PLAN, SQL Trace, hints, Oracle dynamic performance views, indexes, and partitions;
• Develops, manages, and test database back-up and recovery plans, and ensure that storage and archiving procedures are functioning correctly;
• Works closely with IT project managers and programmers on database design and ongoing requests; and
• Implements change controls and insure that changes to the production database are properly coordinated.
Preferred Qualifications
• Experience in Oracle Enterprise version 12c and 19c, especially in Oracle RAC databases.
• Experience in Oracle Database Appliance.
• Experience in Oracle Enterprise Manager.
• Experience in Oracle Database Advanced Security.
• Good problem-solving and analytical skills.
• Good communication, teamwork and negotiation skills.
• Ability to create and maintain strong working relationships with colleagues and customers.
Some positions may require additional credentials or a background check to verify your identity.
Email Address douglas.arthur@dfs.ny.gov
Address
Street One Commerce Plaza, Suite 301
Notes on ApplyingTo Apply: Interested qualified candidates must submit a resume and letter of interest no later than September 29, 2022 to the email address listed below. Please include the Box # (Box ITS 3 DB - 04022) in the subject line of your email to ensure receipt of your application. Email submissions are preferred.
Douglas Arthur
Box ITS 3 DB - 04022
New York State Department of Financial Services
Office of Human Resources Management
One Commerce Plaza, Suite 301
Albany, NY 12257
Email: douglas.arthur@dfs.ny.gov
Fax: (518) 402-5071
Public Service Loan Forgiveness
Employment with New York State qualifies an individual for Public Service Loan Forgiveness (PSLF). This program forgives the remaining balance on any Direct Student Loans after you have made 120 qualifying monthly payments while working full-time for a U.S. federal, state, local, or tribal government or not-for-profit organization. To learn more about the program and whether you would qualify, please visit: https://studentaid.gov/manage-loans/forgiveness-cancellation/public-service
All candidates that apply may not be scheduled for an interview
AMERICANS WITH DISABILITIES ACT: REASONABLE ACCOMMODATIONS
Under the Americans with Disabilities Act (ADA), the Department of Financial Services is required to provide reasonable accommodation for known physical or mental limitations of an otherwise qualified applicant with a disability if an accommodation would enable the applicant to perform the essential functions of the job. If the accommodation would constitute an undue hardship on the operations of the agency, the agency is not required to provide it.