Apply on Employer Site

NEOGOV · 5 months ago

Data Base Administrator 3

DWSD -735 Randolph Detroit MI 48226, MI

Full-time

Onsite

Mid, Senior Level

$78K/yr - $117K/yr

5+ years exp

NEOGOV is a part of the City of Detroit, and they are seeking a Database Administrator to manage the performance, integrity, and security of enterprise databases. The role involves designing, implementing, and maintaining databases while providing technical documentation and support to meet organizational needs.

GovTechHuman ResourcesInformation TechnologySoftware

No H1B

Responsibilities

Lead database design to support user/business needs, application development and implementation efforts, and the project team

Provide direction to solutions involving database activities including physical structure, functional capabilities, security, and back-up/recovery specifications

Provide maintenance of database dictionaries, the overall monitoring of standards and procedures, and the integration of systems through the database design process

Consult, coordinate, and communicate with business units and IT staff providing solutions and recommendations which integrate with current and future database, application, and infrastructure architectures

Design, test, implement, monitor and maintain Oracle and Microsoft SQL Server database systems to meet organizational availability and security requirements

Code and implement database definitions and descriptions; develop and administer database utility routines for verifying the validity of data element values, optimizing performance, backing up and recovering data sources and maintaining the integrity of the organization’s database systems

Provide database requirements, design, installation, support and problem resolution

Maintain and monitor performance, capacity, and availability of organization-wide databases

Provide technical documentation, expertise, training, and consulting related to database creation, maintenance, and uses

Manage database software licensing and database management projects

Responsible for defining technical database design and implementation approaches for IT projects

Follow security and safety policies and procedures in carrying out work duties

Provide on the job training

Assist other IT staff and IT management as needed with overflow activities involving the support and maintenance of computers, printers, applications, databases, networks, servers, storage, and data center facilities, and the installation, decommissioning, and relocation of related IT equipment

Perform related work duties as assigned

Perform backups, restores and non-production Database data refreshes

Implement systems changes in support of performance optimization

Perform database maintenance (table reorganizations, database compaction and generate index statistics)

Develop and maintain database disaster recovery processes

Complete Data model design and maintenance

Generate DDL (data definition language)

Generate SQL writing and tuning

Complete coding stored procedures

Collaborating with developers to help choose the most appropriate DBMS feature/functionality and other pre-production activities

Manage all the application components that interact with the database

Application installation and patching and upgrades

Building and running data cleanup routines and data load process management

Act as one of the foremost technical authorities in the area of database administration

Lead all aspects (which may include other IT disciplines) of database management projects

Plan, design and implement additions, upgrades, replacements, or retirement of database management systems

Responsible for performance, integrity, and security of databases

Execution of planning, coordinating and directing workflow, operations, and employees to create an environment that enables efficient and productive work

Qualification

OracleMicrosoft SQL ServerDatabase AdministrationDatabase DesignData ManagementPerformance MonitoringCustomer ServiceProblem ResolutionTechnical DocumentationTeam Collaboration

Required

A minimum of five (5) years of related work experience

A valid Michigan Driver's License and the ability to drive a motor vehicle on all terrain

Knowledge of enterprise database performance, integrity, and security

Knowledge of principles and practices of the functions performed by IT Services

Knowledge of Oracle and SQL Server relational database management system

Knowledge of concepts, practices and procedures (COBIT and ITIL), including Change Management, Software/Systems Development Life Cycle for IT systems development and management

Knowledge of hardware, software, application, database and network environments currently in use at DWSD

Knowledge of principles and techniques of database and application development and languages in use at DWSD

Knowledge of principles and techniques of systems analysis, design and development lifecycle

Knowledge of installation and maintenance of application and database components

Knowledge of water and wastewater business functions and operations

Skill to install, remove, and make modifications to technology

Skill to apply IT policies and programs in a manner aligned with the DWSD mission, goals, and strategies

Skill to independently, and as part of a team providing timely, high quality customer-focused services

Skill to work in a busy environment, with frequent interruptions and still be able to prioritize and resolve conflicting requests

Skill to work in a professional manner with access to confidential and other data types

Skill to exercise Enterprise management skills

Skill to exercise good judgment, discretion, maintains confidentiality, and work with independence, initiative and professionalism

Skill to work in a team environment that provides the capacity for IT project delivery

Skill to resolve technology and user issues both verbally and in writing to end-users of varying computing skills

Skill to deliver quality written documentation and presentations, including the ability to make technology understandable to end-users

Skill to understand and translate the needs of varied users into IT system requirements

Skill to use advanced technology

Ability to work independently, and as part of a team providing timely, high quality customer-focused services

Ability to demonstrate critical thinking ability

Ability to work in a team environment that provides the capacity for IT project and service delivery

Ability to organize, perform and or coordinate technology tasks and projects

Ability to define appropriate technical approaches and solutions to projects and business initiatives

Ability to determine critical project criteria to ensure project completion

Ability to perform database administration on multiple enterprise application databases

Ability to instruct groups or individuals on technology

Ability to deliver quality customer service to users

Ability to write technical and non-technical documentation

Ability to interact and communicate with IT staff and business users

Ability to apply IT policies and programs in a manner aligned with the Department mission, goals, and strategies

Ability to learn new application software packages, operating systems, and IT processes and procedures

Ability to effectively utilize appropriate safety equipment and procedures

Ability to communicate effectively, both verbally and in writing

Ability to understand and follow verbal and written instructions

Ability to establish and maintain effective working relationships with others

Ability to communicate frequently with the team members and other units across the Department about process, equipment or potential problems

Ability to direct team activities or to work as a team member

Ability to demonstrate leadership skills and mastery of IT principles and procedures

Ability to consult, coordinate, and communicate with business units and IT staff providing solutions and recommendations which integrate with current and future database, application, and infrastructure architectures

Ability to design, test, implement, monitor and maintain Oracle and Microsoft SQL Server database systems to meet organizational availability and security requirements

Ability to code and implement database definitions and descriptions; develop and administer database utility routines for verifying the validity of data element values, optimizing performance, backing up and recovering data sources and maintaining the integrity of the organization's database systems

Ability to be responsible for capacity planning and management, security planning and management, data management, systems maintenance, and performance management of one or more systems

Ability to provide database requirements, design, installation, support and problem resolution

Ability to maintain and monitor performance, capacity, and availability of organization-wide databases

Ability to provide technical documentation, expertise, training, and consulting related to database creation, maintenance, and uses

Ability to provide technical support resolving incidents, including creating, and closing tickets

Ability to manage database software licensing and database management projects

Ability to plan, design, and implement IT-related policies and procedures

Ability to document system problems and resolutions for future reference

Ability to define technical database design and implementation approaches for IT projects

Ability to provide technical expertise, consulting, and training related to database development and management

Ability to follow security and safety policies and procedures in carrying out work duties

Ability to provide on the job training

Ability to perform related work duties as assigned

Ability to manage database systems installations and configuration

Ability to perform backups, restores and non-production Database data refreshes

Ability to implement systems changes in support of performance optimization

Ability to perform database maintenance (table reorganizations, database compaction and generate index statistics)

Ability to develop and maintain database disaster recovery processes

Ability to complete Data model design and maintenance

Ability to generate DDL (data definition language)

Ability to generate SQL writing and tuning

Ability to complete coding stored procedures

Ability to collaborate with developers to help choose the most appropriate DBMS feature/functionality and other pre-production activities

Ability to manage all the application components that interact with the database

Ability to perform application installation and patching and upgrades

Ability to build and run data cleanup routines and data load process management

Ability to act as one of the foremost technical authorities in the area of database administration

Ability to lead all aspects (which may include other IT disciplines) of database management projects

Ability to plan, design and implement additions, upgrades, replacements, or retirement of database management systems

Ability to be responsible for performance, integrity, and security of databases

Ability to execute planning, coordinating and directing workflow, operations, and employees to create an environment that enables efficient and productive work

Preferred

Master's Degree preferred

Benefits

Medical - Eligible for hospital, surgical, and prescription drug benefits.

Dental

Vision

Life Insurance - Optional group insurance available to employee and their family. The City pays 60% of premium for first $12,500 of employee life insurance. Employee may purchase, at own expense, life insurance for spouse and each dependent.

Long-Term Disability Insurance (Income Protection Plan) - The City offers disability insurance through payroll deductions for persons who become disabled and who are not yet eligible for a service retirement.

Sick Leave

Vacation

Holidays

Funeral leave

Family and Medical Leave

Jury duty

Military duty leave

Unpaid personal leave

City Employees Retirement System

ADVANCEMENT OPPORTUNITIES - Employees have many opportunities for growth and career advancement throughout all City departments and divisions.