- Hourly / - BiWeekly /
- Monthly / $73,541.00-$118,085.00 Yearly
As a housing finance agency, Housing and Community Development (HCD) offers a broad range of financial services that include bond finance, mortgage lending, municipal and small business lending, cashflow loans, tax credit programs and loan servicing, as well as housing voucher and grant administration for community revitalization. HCD’s commercial partnerships and stakeholders include community and investment banks, sub-services, trustees and bond holders.
HCD lending and financing programs are inherently time critical, and there are extensive dependencies on personally identifiable information (PII), as well as other sensitive and non-public information.
A Database Administrator III is the senior level position for optimizing database design, resources and access, and implementing and maintaining optimum database configuration, integrity and performance. Employees in this class do not supervise. They have extensive interaction with software/database developers, and stakeholders at partner organizations, and all levels of program (line-of-business) staff.
The employees in this classification receive general supervision, provides timely, and creative solutions to end-user computer and networking problems of a complex nature to ensure end-user productivity.Database Administrator I, Database Administrator II, and Database Administrator III are differentiated
Enable Department to expediently respond to opportunities and challenges via Information Technology;
Administer multiple databases of varying complexity with regard to database size, stored procedures and interfaces;
Support concurrent database users while ensuring control, security, and data integrity;
Develop design for physical data storage, and also account and security administration;
Implement backup and recovery procedures for database management systems;
Define database parameters, logical data models, data repository requirements, data dictionaries and warehousing requirements;
Develop strategies for protecting Personally Identifiable Information (PII) using encryption in transit and at rest;
Deploy new relational database systems, which may be on-premises, or hosted or on the Cloud;
Participate in development of IT policies, security controls, and disaster recovery;
Performs other related duties.
Knowledge of line-of-business programs, their respective missions, and the role of information technology;
Knowledge of relational databases and client-server software;
Knowledge of SDLC and programming languages;
Knowledge of computer operating systems, computer networks, hosted and cloud-based solutions;
Skill working with larger and more complex databases;
Skill using relational database management toolkits, and developing stored procedures;
Skill integrating database accounts with domain accounts, such as via Active Directory;
Skill tuning enterprise databases to achieve optimum performance levels;
Skill in delivering solutions and achieving outcomes via Information Technology;
Ability to analyze organizational needs, architect business solutions, and monitor/administer systems/software to optimize performance;
Ability to use acquired institutional knowledge to achieve organizational efficiencies;
Ability to lead projects;
Ability to trace and diagnose database performance issues;
Ability to develop databases and software according to AGILE;
Ability to mentor and provide guidance for Junior database administrators.
Education: Typically requires a Bachelor's degree
Experience: Four or more years of experience performing database development and administration for multi-tiered client-server software in an organization with extensive level of program integration and reliance on technology
Notes: 1. Graduation from an accredited high school or possession of a high school equivalency certificate plus thirty credit hours from an accredited college or university in Computer Information Technology, Management Information Systems, Computer Science or other information technology-related field to include course work in database management systems may be substituted for the required education.
2. Graduation from an accredited high school or possession of a high school equivalency certificate and one additional year of experience designing, developing, testing, implementing and maintaining applications systems and programs using generally accepted computer programming languages or maintaining and modifying operating systems for computers may be substituted for the required education.
3. Experience operating computer systems; or scheduling, controlling input and output or maintaining a tape library to process data on computer systems; or converting data from project specifications by developing program code using generally accepted computer programming languages may be substituted for high school education on a year-for-year basis.
Class specifications are broad descriptions covering groups of positions used by various State departments and agencies. Position descriptions maintained by the using department or agency specifically address the essential job functions of each position.
Director, Division of Classification and Salary