Job Title: Database Administrator
Location: Detroit, MI
Skills & Experience:
- Candidates must possess technical oriented skills with high precision and attention to detail.
- Desk side support experience required
- 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.
- Installing and configuring enterprise applications
- Active Directory experience
Job Purpose:
The purpose of this position is to provide database integration and administration services to support operations and internal Projects.
Duties & Responsibilities:
The primary duties and responsibilities of this position are to lead database design to support user/business needs, application development and implementation efforts, and the project team within the client.
Tasks for Database Administrator will include but not be limited to:
- Principles and practices of the functions performed by IT Services
- Oracle and SQL Server relational database management system
- 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 used typically at utilities.
- Principles and techniques of systems analysis, design and development lifecycle
- Installation and maintenance of application and database components
- Water and wastewater business functions and operations
- 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.
- Responsible for capacity planning and management, security planning and management, data management, systems maintenance, and performance management of one or more systems
- 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)
- Define technical database design and implementation approaches for IT projects.
Qualifications:
- Required: Bachelor of Computer Science or Related Field (4 years’ experience in lieu)
- Ability to resolve technical issues and respond to support requests supporting team members on various software applications, hardware, and operating systems on Windows and Android devices
- 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.
- Provide technical documentation, expertise, training, and consulting related to database creation, maintenance, and uses.
- Excellent verbal and written communication skills
- Keen sense of accuracy and quality of work.
- Desk side support experience required
- Highly Motivated, Team Oriented and Process Driven
- Ability to learn in a fast paced environment through both self-directed learning
Physical Requirements:
- Onsite presence required 8:30am – 5:00pm Monday – Friday
- As-needed earlier start times may be needed in prep of planned deployments to accommodate 30-minute arrival prior to employees supported.
- Weekends may be required
Job Types: Full-time, Contract
Benefits:
- Employee discount
- Life insurance
- Referral program
Schedule:
- 8 hour shift
Experience:
- MySQL: 5 years (Preferred)
- Database administration: 5 years (Preferred)
- Oracle: 5 years (Preferred)
Work Location: On the road