- Hourly / - BiWeekly /
- Monthly / $46,942.00-$74,933.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 Trainee has no experience or training, but demonstrates an aptitude to perform database design, optimization, and administration. Employees in this class do not supervise.
The employees in this classification receive constant oversight for their tasks and assignments.
Database Administrator Trainee and Database Administrator I can be distinguished by virtue that the Trainee has no ability to perform technical assignments without direction and guidance.
Will shadow more senior employees as they perform a full range of technical duties;
Develop understanding and proficiency with commodity technologies utilized by agency;
Enable Department to expediently respond to opportunities and challenges via Information Technology;
Administer and support multiple databases of varying complexity as impacted by database size, technology, 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.
All technical knowledge, skill and ability for a Trainee-level employee will be limited;
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 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 trace and diagnose database performance issues;
Ability to develop databases and software according to AGILE;
Ability to mentor and provide guidance for staff performing data extractions and queries.
Education: High school diploma or equivalent
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