Development Database Administrator (Grade 17)

Nature of Work

This is technical work involving administration and technical support for all city database environments. Work involves supporting the Database Administrator with management and administration of City databases and the development of computer software applications. The Development Database Administrator works closely with the Application Development team ensuring database code meets standards for readability, reliability and performance and assisting with application development and support. Work is performed with independence for initiative, judgment and action. Work is reviewed for adherence to policies and procedures, and for results achieved. Assists developers in all phases of the software development life cycle. Serves as direct support to the primary database administrator. Assist with installs and SQL server configuration, upgrades, patches and database migrations. Creates, schedules, and maintains database maintenance jobs including backups, integrity checks, and re-indexing. Maintains database security and user access to databases through Active Directory and Microsoft SQL user accounts. Troubleshoots databases as needed to resolve errors. Generates ad hoc queries and user requested changes to databases. Writes and maintains SQL queries and stored procedures. Monitors and administers databases including responsibility for backup operations and optimizing database performance or as directed by the Database Administrator. Creates and modifies application database objects. Supports city staff by designing, developing, maintaining views, reports, and other business intelligence solutions such as SQL Server Integration Services Packages for complex/multiple databases to provide information in useable format. Acts as a mentor and consultant to the development staff ensuring adherence to ANSI SQL Standards, enforcing database integrity and assuring normalization. Assists in data analysis and maintains/reviews physical data models with development teams. Designs and develops complex software and related components both independently and as part of a team. Tests, analyzes, modifies, implements, and supports cutting-edge web, mobile or client/server business applications using advanced software development tools and techniques. Develops custom interfaces as required for new or existing application programs. Analyzes requirements and translates business requirements into product designs. Writes technical specifications and other forms of documentation and improves existing applications as required. Assists and trains subordinate personnel in programming languages and techniques. Assists with design, development, testing and support of software applications. Requires regular and prompt attendance plus the ability to work well with others and work well as a team.

PHYSICAL AND ENVIRONMENTAL FACTORS:

Work is essentially sedentary with occasional walking and standing. Computer work requires manual dexterity. The work environment involves everyday risks or discomforts which require normal safety precautions typical of offices.

Minimum Education, Training and Experience

Bachelor’s Degree in Computer Science or a related field from a college or university accredited by a regional accrediting agency recognized by the U.S. Department of Education and experience in the field of information technology using relational database management systems. Five years of progressive experience developing complex database-based applications in a Microsoft windows environment is required. Three years of progressive experience using Microsoft SQL Server Management Studio is required. Training, or preferably, certification in Microsoft development methodologies and products is desirable (.Net, Visual Basic, Visual C++, SQL Server). Training, or preferably, certification in Microsoft SQL Server administration is highly desirable. Considerable knowledge of computerized applications, multi-platform computer languages, programming and information technology. Knowledge of current principles and practices of modern database technologies, Microsoft SQL Server database methodologies, structured query language, stored procedures, and table normalization standards. Knowledge of recent developments in the field of information technology. Knowledge of laws and ordinances affecting information technology. Knowledge of management and public administration principles and procedures and the functions and needs of municipal departments. Ability to communicate, both orally and in writing and to translate technical terminology in terms understandable to non-technical employees.

NECCESSARY SPECIAL REQUIREMENTS:
None

The City of Huntsville offers a competitive benefits package for its regular, full-time employees, such as medical, dental, vision, life, accidental death & dismemberment, cancer, off-the-job accident, as well as annual leave, sick leave, holiday and retirement.

Below is a summary of the City’s benefit offerings:

Medical Insurance:

The City offers all regular, full-time employees a medical insurance plan administered by Blue Cross Blue Shield of Alabama. There is one option available: BlueCard PPO. The BlueCard PPO plan utilizes a national Preferred Provider Organization. There is a 30 day waiting period from date of hire.

Voluntary Dental Plan:

The City offers a voluntary dental plan for all regular, full-time employees administered by Delta Dental Insurance Company. This is a PPO plan which offers a network of providers who have agreed to accept reduced fees for their services. Any provider may be utilized; however, significantly less out-of-pocket expense is realized when using a PPO provider. There is one level of coverage available: Level 2 plan. The Level 2 plan offers 100% coverage for Preventive and Diagnostic Services, 80% coverage for Basic Services and 50% coverage for Major Services and Orthodontic, if a PPO provider is utilized. There are no individual/family deductibles for Preventive and Diagnostic Services and deductibles for Basic, Major and other Covered Services are $50 per person or $150 per family per calendar year. The plan maximum is $1,000 and Preventive and Diagnostic Services do not count toward the annual maximum. There is a 30 day waiting period from date of hire.

Voluntary Vision Plan:

This is a voluntary vision plan that provides benefit coverage for eye examinations, frames, and eyeglass lenses with applicable copay. There is also an allowance for contact lenses. The plan is administered by VSP. There is a 30 day waiting period from date of hire.

Mental Health/Substance Abuse Program:

A mental health and substance abuse program is offered through Behavioral Health Systems, Incorporated (BHS). It is available to all employees and covered dependents currently enrolled and participating in the Group Medical Insurance. All treatment must be pre-certified and approved through BHS. To arrange for an evaluation, call the City’s Employee Assisted Services Coordinator or BHS prior to treatment being rendered. There is a 30 day waiting period from date of hire.

Life Insurance:

The City provides a $20,000 life insurance policy. There are additional benefits for accidental death & dismemberment, seat belt, airbag rider and common carrier. Coverage begins after completing one full day of work. Coverage is provided at no-cost to the employee.

Disability Insurance:

The City provides a limited long term disability policy for eligible employees with one year of service, but less than ten years of service. After ten years of service, disability benefits are coordinated by the Retirement System of Alabama (RSA).

Retirement:

The retirement plan is administered by the Retirement System of Alabama (RSA). Participation is mandatory for all regular, full-time and part-time employees. Tier II Employees contribute 6% of salary to the plan (7% of salary for certain positions in the Police and Fire & Rescue divisions). Tier I Employees contribute 5% of salary to the plan (6% of salary for certain positions in the Police and Fire & Rescue divisions). The City contributes a percent as determined by RSA.

Voluntary Life / AD&D Insurance:

The City offers regular, full-time employees an optional voluntary term life insurance plan. Employees may purchase additional term life insurance for self and spouse and/or eligible dependents. Premiums are based upon age for the employee and spouse. Premiums for children are based upon a flat rate. Also, the City offers an optional voluntary accidental death & dismemberment insurance plan. Employees may purchase insurance for self or family. The minimum level of coverage on both plans is $20,000. The plans are administered by Lincoln Financial Group. There is a 30 day waiting period from the date of hire. Please refer to the plan brochure for additional information.

Voluntary Supplemental Insurance:

The City offers an optional supplemental Cancer plan and an Off-The-Job Accident plan. The Cancer plan provides a first occurrence, hospital confinement, radiation & chemotherapy and other benefits. The Off-The-Job Accident plan pays benefits for injuries occurring off the job. These supplemental plans are administered by Allstate. Please refer to the brochure for an explanation of covered benefits. There is a 30 day waiting period from date of hire.

Flexible Spending Accounts:

The City provides two flexible spending accounts: medical reimbursement and dependent care accounts. Reimbursements from these pre-taxed accounts require a proper receipt. The plans are administered by Wage Works. There is a 30 day waiting period from date of hire.

Voluntary Deferred Compensation Plans:

The City provides two optional voluntary deferred compensation plans. One plan is administered by RSA-1 and the other is administered by Nationwide Retirement Solutions. Employees may defer portions of salary for a later date, such as retirement. Please see the Payroll Division of the Finance Department for further details.

College 529 Savings Program:

The City provides an opportunity for employees to set aside funds for education through payroll deductions. For additional information, contact the City’s Insurance and Benefits Office.

Holidays:

The City recognizes the following holidays: New Years Day, Martin Luther King, Memorial Day, Independence Day, Labor Day, Veterans Day, Thanksgiving Day, and Christmas Day. Three additional floating holidays are given each year as authorized by the Mayor.

Sick Leave:

Sick leave accrual is 4 hours per pay period for all eligible City employees. There is no maximum amount of sick leave an employee may accrue.

Annual Leave:

Annual leave is accrued as follows: less than 10 years = 4 hours per pay period; 10 to 15 years = 5 hours per pay period; 15 to 20 years = 6 hours per pay period; 20 or more years = 7 hours per pay period. Employees may accrue and carry forward 260 hours to the next calendar year.

Military Leave:

The City provides a military leave plan that pays regular salary for not more than twenty-one days per year. Also, employees, called into active service, may receive compensation in an amount equal to the difference in the lower military pay and the higher public employment salary as provided by City Council Ordinance.

Longevity Pay:

The City pays eligible employees compensation based upon the number of months of continuous regular full-time service as of October 1st of each year.

Other Benefits:

Please refer to the City of Huntsville Personnel Policies and Procedures Manual.