Lansing, Michigan
Database Administrator 4 #949520Brief Description of Work:
- Design and supervise overall development of Data Mart and Oracle-hosted dimensional models.
- Create ETL designs to provide easy accession to data marts.
- Troubleshoot and resolve data model issues.
- Test and monitor alterations in designs.
- Maintain data marts in accordance with agency requirements and practices.
- Create database models which serve as blueprints for project engagements of all complexities.
- Develop data warehousing hardware and software platforms and integrate systems to ensure that integration is effective and meets client specifications.
- Translate business requirements and models into feasible and acceptable data warehouse designs.
- Design and oversee the implementation of data transformation and change processing procedures to ensure that data from multiple sources is aggregated, normalize, and update and then publish to multiple target environments.
- Establish data standards and policies, data modeling, systems architecture design, and migration system architectures to ensure access to and integrity of data assets
- Develop strategies and parameters, to ensure cost effectiveness and system efficiency
- Evaluate reusability of current data for additional analysis, while maintaining integrity and confidentiality of information.
- Develop data warehousing hardware and software platforms and integrate systems to ensure that integration is effective and meets client specifications.
- Provide maintenance, support, and assistance to specialist DBAs with installation and configuration of clustered database failover, database replication solutions, and database backup solutions.
- Install database management software and database patches in any environment.
- Review, install, analyze, and implement security patches to be applied to remain
- CJIS compliant, Payment Cared Industry (PCI) compliant, and Michigan Cyber Security compliant.
- Establish standards and guidelines for database space allocation based on best practices and implementation considerations based on business requirements.
- Measure and/or forecast current capacity, gauge the growth of capacity over time, and factor in the anticipated capacity requirements to determine whether the existing infrastructure can sustain the anticipated workload.
- Research, analyze, and determine appropriate changes to DBMS parameters to support future application and database needs.
- Research, analyze, and determine appropriate hardware changes to support future application and database needs.
- Report recommendations to appropriate DBA specialist and/or technical services.
- Implement data encryption.
- Perform Data Export/Import/Load and data transformations between databases in production environments.
- Perform production data file transfers between different systems, across state agencies, federal government, vendors, etc.
- Must have thorough knowledge of Oracle materialized views, Oracle partitioning.
- Perform database performance tuning by identifying index candidates, updating database statistics, using appropriate optimization techniques, optimizer hints and other methods.
- Document tuning procedures.
- Implement defined initialization parameters, database instance memory structures and physical data layout for optimal performance.
- Monitor database jobs and scheduled processes, perform troubleshooting and provide resolution for any issues with jobs/processes as necessary.
- Document solution and provide root cause analysis.
- Coordinate with vendor support to address technical issues that could not be resolved in-house.
We need a staff Aug with below specified requirements:
- Experience in Data Modeling and designing Datawarehouse databases, Required 8+ years.
- Experience in Data Replication using tools like Oracle Golden Gate, Required 8+ years.
- Experience in Oracle Database administration, PL/SQL, packages, security, and stored procedures, Required 12+ years.
- Knowledge in design, development, implementation, and documentation of data systems.
- Experience in performance tuning, Required 10+ years.
- Vast experience in LINUX systems, Required 10+ years.
- Extensive working experience in RAC environments, Required 10+ years.
- Experience using Oracle Data Guard / Fast Start Failover, Required 5+ years.
- Database programming experience in data migration and conversion practices, Required 8+ years
- Writing Oracle packages, procedures, and functions, Required 10+ years
- Designing, creating, normalizing and maintenance of oracle database objects, Required 10+ years.
- Designing logical and physical database model, Required 10+ years
- Data analysis and management, Required 10+ years
- Experience in developing using ETL software. Desired 8+ years
Additional Info:
At FastTek Global, Our Purpose is Our People and Our Planet. We come to work each day and are reminded we are helping people find their success stories. Also, Doing the right thing is our mantra. We act responsibly, give back to the communities we serve and have a little fun along the way.
We have been doing this with pride, dedication and plain, old-fashioned hard work for 24 years!
FastTek Global is a financially strong, privately held company that is 100% consultant and client focused.
We've differentiated ourselves by being fast, flexible, creative and honest. Throw out everything you've heard, seen, or felt about every other IT Consulting company. We do unique things and we do them for Fortune 10, Fortune 500, and technology start-up companies.
Our benefits are second to none and thanks to our flexible benefit options you can choose the benefits you need or want, options include:
- Medical and Dental (FastTek pays majority of the medical program)
- Vision
- Personal Time Off (PTO) Program
- Long Term Disability (100% paid)
- Life Insurance (100% paid)
- 401(k) with immediate vesting and 3% (of salary) dollar-for-dollar match
Plus, we have a lucrative employee referral program and an employee recognition culture.
FastTek Global was named one of the Top Work Places in Michigan by the Detroit Free Press in 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020, 2021, and 2022!
To view all of our open positions go to: https://www.fasttek.com/fastswitch/findwork
Follow us on Twitter: https://twitter.com/fasttekglobal
Follow us on Instagram: https://www.instagram.com/fasttekglobal
Find us on LinkedIn: https://www.linkedin.com/company/fasttek
You can become a fan of FastTek on Facebook: https://www.facebook.com/fasttekglobal/