City of Detroit
Data Base Administrator 2
City of Detroit, Detroit, Michigan, United States, 48228
Data Base Administrator 2
Print (https://www.governmentjobs.com/careers/detroit/jobs/newprint/4719851)
Apply
Data Base Administrator 2
Salary
$110,081,920.00 - $197,681,120.00 Annually
Location
DWSD -735 Randolph Detroit MI 48226, MI
Job Type
Classified- Regular (DWSD Only)
Job Number
MM-112024-501039
Department
Water Department
Opening Date
11/05/2024
Closing Date
11/14/2024 11:59 PM Eastern
Bargaining Unit
9000-Non Union Salary Regular Service General
Description
Benefits
Description
This is not a Civil Service Position. DWSD employees are subject to provisions of Court Orders entered in United States District Court, Eastern District of Michigan, Southern Division, Case No. 77-71100 with regard to certain terms and conditions of employment. DWSD does not honor reversion rights for internal candidates.
The Database Administrator operates under limited supervision and manages performance, integrity and security of DWSD databases. Designs, implements, and maintains databases with respect to access time, access methods, device allocation, validation checks, organization, protection and security, documentation, guidelines, and statistical methods.
ESSENTIAL JOB FUNCTIONS:
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. Provide technical documentation, expertise, training, and consulting related to
database creation, maintenance, and uses.
Examples of Duties
RELATED JOB FUNCTIONS:
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.
REQUIRED KNOWLEDGE, SKILLS AND ABILITIES
KNOWLEDGE OF:
Database performance, integrity, and security
Proven knowledge working with Oracle-based technologies required, 3-5 Years
Ability to maintain OLTP databases required, 3-5 Years
Knowledge of PL/SQL, DDL and SQL required, 3-5 Years
Knowledge of system and application security threats and vulnerabilities
Excellent communication skills, verbal and written
Concepts, practices and procedures (COBIT and ITIL), including Change Management, Software/Systems Development Life Cycle for IT systems development and management
Hardware, software, application, database and network environments currently in use at DWSD
Principles and techniques of systems analysis, design and development lifecycle
SKILL TO:
Install, remove, and make modifications to technology
Apply IT policies and programs in a manner aligned with the DWSD mission, goals, and strategies
Independently, and as part of a team providing timely, high quality customer-focused services
Work in a busy environment, with frequent interruptions and still be able to prioritize and resolve conflicting requests
Work in a professional manner with access to confidential and other data types
Exercise good judgment, discretion, maintains confidentiality, and work with independence, initiative and professionalism
Work in a team environment that provides the capacity for IT project delivery
Resolve technology and user issues both verbally and in writing to end-users of varying computing skills
Deliver quality written documentation and presentations, including the ability to make technology understandable to end-users
Understand and translate the needs of varied users into IT system requirements
Use advanced technology
ABILITY TO:
Work independently, and as part of a team providing timely, high quality customer-focused services
Demonstrate critical thinking ability
Work in a team environment that provides the capacity for IT project and service delivery
Organize, perform and or coordinate technology tasks and projects
Define appropriate technical approaches and solutions to projects and business initiatives
Determine critical project criteria to ensure project completion
Perform database administration on multiple enterprise application databases
Instruct groups or individuals on technology
Deliver quality customer service to users
Minimum Qualifications
REQUIRED EDUCATION AND EXPERIENCE (position requirements at entry)
Bachelor's degree in Information Technology, Computer Science, Business Administration, or related discipline or professional Certification from Oracle
3 – 5 years as Oracle DBA on Oracle 12c or higher in clustered environments
Excellent communication skills, verbal and written
Supplemental Information
ESSENTIAL REQUIREMENTS
Physical Requirements:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential duties of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties.
This position requires physical ability to climb, balance, stoop, kneel, crouch, crawl, reach, stand, walk, push, pull, lift, finger, grasp, feel, talk, hear see, and perform repetitive motions. Essential duties require the mental and/or physical ability to work in a standard office environment; read fine print on blueprints and display terminals; converse by telephone, two-way radio and in person using writing instruments, calculators, and personal computers; and strength to lift and carry up to 40 pounds. The work requires the ability to distinguish colors and to hear audible alarms. Incumbents may be subject to potentially hazardous physical conditions, atmospheric conditions, extreme temperatures, intense noise, and/or vehicle traffic. Employees will also be required to pass a bio-mechanical physical.
Environmental Working Requirements:
Work is performed within an office, plant environment, remote sites, or other locations within the DWSD Service Area. Employees within this classification may be exposed to dust and electrical connections, and frequent work with computer equipment.
OTHER REQUIREMENTS
Must have a valid Michigan Driver’s License
Ability to work irregular hours, to commute to DWSD facilities and work sites, and respond to after hour emergencies and on-call responses.
The above statements describe the general nature and level of work performed by employees assigned to the class. Incumbents may be required to perform job-related responsibilities and tasks other than those stated in this specification. Specific job duties may vary from position to position. Employees in this class are required to undergo alcohol and drug screening and are subject to a criminal background investigation.
EMPLOYMENT BENEFITS
The City of Detroit offers a competitive and comprehensive employee benefit package. We pride ourselves on the longevity of our employees. Part of the reason for the low turnover rate is the exceptional benefit package listed below. Benefits include, but are not limited to the following:
HEALTH
Medical - Eligible for hospital, surgical, and prescription drug benefits.
Dental
Vision
INSURANCE
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.
PAID TIME OFF
Sick Leave
Vacation
Holidays
OTHER LEAVE BENEFITS
The City also has the following paid and unpaid leaves; funeral leave, Family and Medical Leave, jury duty, military duty leave, unpaid personal leave,
RETIREMENT BENEFITS
City Employees Retirement System
As a regular City employee you automatically become a member of the General Retirement System. This entitles you to a retirement allowance after:
• Completion of thirty (30) years of service;
At age sixty (60) if you have at least ten (10) years of service, or
At age sixty-five (65) with eight (8) years of service.
• In the event of disability, other eligibility rules apply);
An early, actuarially reduced, retirement is offered after you have attained at least twenty-five (25) years of service;
• Employees are vested after ten (10) years of service, regardless of age.
ADVANCEMENT OPPORTUNITIES - Employees have many opportunities for growth and career advancement throughout all City departments and divisions.
Have a successful career with the City of Detroit. Always remember that you are a part of a team with a common Vision of delivering excellent service to the citizens of the City of Detroit.
Agency
City of Detroit
Address
Coleman A. Young Municipal Center 2 Woodward Ave ste 316 Detroit, Michigan, 48226
Website
http://www.detroitmi.gov/Detroit-Opportunities/Find-A-Job
Apply
Please verify your email address Verify Email
Print (https://www.governmentjobs.com/careers/detroit/jobs/newprint/4719851)
Apply
Data Base Administrator 2
Salary
$110,081,920.00 - $197,681,120.00 Annually
Location
DWSD -735 Randolph Detroit MI 48226, MI
Job Type
Classified- Regular (DWSD Only)
Job Number
MM-112024-501039
Department
Water Department
Opening Date
11/05/2024
Closing Date
11/14/2024 11:59 PM Eastern
Bargaining Unit
9000-Non Union Salary Regular Service General
Description
Benefits
Description
This is not a Civil Service Position. DWSD employees are subject to provisions of Court Orders entered in United States District Court, Eastern District of Michigan, Southern Division, Case No. 77-71100 with regard to certain terms and conditions of employment. DWSD does not honor reversion rights for internal candidates.
The Database Administrator operates under limited supervision and manages performance, integrity and security of DWSD databases. Designs, implements, and maintains databases with respect to access time, access methods, device allocation, validation checks, organization, protection and security, documentation, guidelines, and statistical methods.
ESSENTIAL JOB FUNCTIONS:
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. Provide technical documentation, expertise, training, and consulting related to
database creation, maintenance, and uses.
Examples of Duties
RELATED JOB FUNCTIONS:
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.
REQUIRED KNOWLEDGE, SKILLS AND ABILITIES
KNOWLEDGE OF:
Database performance, integrity, and security
Proven knowledge working with Oracle-based technologies required, 3-5 Years
Ability to maintain OLTP databases required, 3-5 Years
Knowledge of PL/SQL, DDL and SQL required, 3-5 Years
Knowledge of system and application security threats and vulnerabilities
Excellent communication skills, verbal and written
Concepts, practices and procedures (COBIT and ITIL), including Change Management, Software/Systems Development Life Cycle for IT systems development and management
Hardware, software, application, database and network environments currently in use at DWSD
Principles and techniques of systems analysis, design and development lifecycle
SKILL TO:
Install, remove, and make modifications to technology
Apply IT policies and programs in a manner aligned with the DWSD mission, goals, and strategies
Independently, and as part of a team providing timely, high quality customer-focused services
Work in a busy environment, with frequent interruptions and still be able to prioritize and resolve conflicting requests
Work in a professional manner with access to confidential and other data types
Exercise good judgment, discretion, maintains confidentiality, and work with independence, initiative and professionalism
Work in a team environment that provides the capacity for IT project delivery
Resolve technology and user issues both verbally and in writing to end-users of varying computing skills
Deliver quality written documentation and presentations, including the ability to make technology understandable to end-users
Understand and translate the needs of varied users into IT system requirements
Use advanced technology
ABILITY TO:
Work independently, and as part of a team providing timely, high quality customer-focused services
Demonstrate critical thinking ability
Work in a team environment that provides the capacity for IT project and service delivery
Organize, perform and or coordinate technology tasks and projects
Define appropriate technical approaches and solutions to projects and business initiatives
Determine critical project criteria to ensure project completion
Perform database administration on multiple enterprise application databases
Instruct groups or individuals on technology
Deliver quality customer service to users
Minimum Qualifications
REQUIRED EDUCATION AND EXPERIENCE (position requirements at entry)
Bachelor's degree in Information Technology, Computer Science, Business Administration, or related discipline or professional Certification from Oracle
3 – 5 years as Oracle DBA on Oracle 12c or higher in clustered environments
Excellent communication skills, verbal and written
Supplemental Information
ESSENTIAL REQUIREMENTS
Physical Requirements:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential duties of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential duties.
This position requires physical ability to climb, balance, stoop, kneel, crouch, crawl, reach, stand, walk, push, pull, lift, finger, grasp, feel, talk, hear see, and perform repetitive motions. Essential duties require the mental and/or physical ability to work in a standard office environment; read fine print on blueprints and display terminals; converse by telephone, two-way radio and in person using writing instruments, calculators, and personal computers; and strength to lift and carry up to 40 pounds. The work requires the ability to distinguish colors and to hear audible alarms. Incumbents may be subject to potentially hazardous physical conditions, atmospheric conditions, extreme temperatures, intense noise, and/or vehicle traffic. Employees will also be required to pass a bio-mechanical physical.
Environmental Working Requirements:
Work is performed within an office, plant environment, remote sites, or other locations within the DWSD Service Area. Employees within this classification may be exposed to dust and electrical connections, and frequent work with computer equipment.
OTHER REQUIREMENTS
Must have a valid Michigan Driver’s License
Ability to work irregular hours, to commute to DWSD facilities and work sites, and respond to after hour emergencies and on-call responses.
The above statements describe the general nature and level of work performed by employees assigned to the class. Incumbents may be required to perform job-related responsibilities and tasks other than those stated in this specification. Specific job duties may vary from position to position. Employees in this class are required to undergo alcohol and drug screening and are subject to a criminal background investigation.
EMPLOYMENT BENEFITS
The City of Detroit offers a competitive and comprehensive employee benefit package. We pride ourselves on the longevity of our employees. Part of the reason for the low turnover rate is the exceptional benefit package listed below. Benefits include, but are not limited to the following:
HEALTH
Medical - Eligible for hospital, surgical, and prescription drug benefits.
Dental
Vision
INSURANCE
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.
PAID TIME OFF
Sick Leave
Vacation
Holidays
OTHER LEAVE BENEFITS
The City also has the following paid and unpaid leaves; funeral leave, Family and Medical Leave, jury duty, military duty leave, unpaid personal leave,
RETIREMENT BENEFITS
City Employees Retirement System
As a regular City employee you automatically become a member of the General Retirement System. This entitles you to a retirement allowance after:
• Completion of thirty (30) years of service;
At age sixty (60) if you have at least ten (10) years of service, or
At age sixty-five (65) with eight (8) years of service.
• In the event of disability, other eligibility rules apply);
An early, actuarially reduced, retirement is offered after you have attained at least twenty-five (25) years of service;
• Employees are vested after ten (10) years of service, regardless of age.
ADVANCEMENT OPPORTUNITIES - Employees have many opportunities for growth and career advancement throughout all City departments and divisions.
Have a successful career with the City of Detroit. Always remember that you are a part of a team with a common Vision of delivering excellent service to the citizens of the City of Detroit.
Agency
City of Detroit
Address
Coleman A. Young Municipal Center 2 Woodward Ave ste 316 Detroit, Michigan, 48226
Website
http://www.detroitmi.gov/Detroit-Opportunities/Find-A-Job
Apply
Please verify your email address Verify Email