Database Developer Capgemini
- 3.7 Salt Lake City, UT Job Details Contract $32.36
- $50.
56 an hour 6 hours ago Benefits Health insurance Dental insurance Vision insurance Retirement plan Qualifications AI models Performance dashboard reports Commercial use (data warehousing systems) Sage Data Integration (Data management) Predictive modeling analysis System troubleshooting Automation Database backup and recovery IT system monitoring Dashboard creation Data retrieval time improvement Business intelligence report generation Dashboard creation support Classification (ML) Stored procedures SQL Database server management Outlier detection Data backup Predictive analytics projects AI-driven automation System tuning System performance monitoring Full Job Description Salt Lake City, UT, United States (On-site) Contract (1 year 5 months 12 days) Published 6 hours ago sql development data warehousing database troubleshooting performance monitoring Cross
- Functional Coordination Python database administration AI/ML Our client is looking for a highly skilled and experienced Software Engineer
- Database Developer to join our outstanding Engineering team. As a Software Engineer
- Database Developer, you will play an important role in maintaining and updating our databases, ensuring accurate data analysis and reporting.
You will also collaborate with other team members to efficiently implement new queries, resolve any issues with automated jobs, and improve performance. More importantly Leverage AI-driven techniques to automate error classification, enable predictive analytics for recurring issues, and deliver intelligent reporting, dashboards, and optimized data retrieval solutions.
Key Responsibilities :
Data Base Administration:
Management of the data extractions from the SAGE Datawarehouse cubes (this requires, troubleshooting, maintenance and modifications as necessary) Ensures that the servers hardware and software are updated (RARS mainly) Making sure that the new drivers, plug-ins are updated. Make sure to run the maintenance services , keep the indexes up to day, adapt to the IT network changes, protection against virus, etc. Monitoring of the performance of the hardware and software Preserving data. Organize the data and secure backups Changes to the server configuration as needed Reporting (Error summary and system and shot reports) Maintain both data bases: the internal reporting and the IB one Update the look up tables for new errors and new classification of errors per weight and functional category Update the cubes to allow queries that are required to analyze the data Create new queries that allow to get the necessary reports from the existing cubes (internal testing and install base) Monitor and troubleshooting of the daily automated jobs to run the reports. Work with other resources when there are issues or modification are needed with the SAGE DW interface Pre-emptive maintenance, look for data clogs and issue on the reports generation Update the stored procedures for the excel reports with new errors, remove previous ones, add system info, etc AI/ML-driven tools and techniques for: Database performance optimization (query tuning, indexing strategies, workload prediction) Intelligent anomaly detection in system performance and data flows Predictive maintenance of database infrastructure AI Integration in Reporting Leverage AI techniques for: Automated error classification and pattern detection Predictive analytics for identifying recurring system/reporting issues Intelligent report generation and recommendation systems Build and maintain smart dashboards with predictive insights and anomaly alerts. Use AI-assisted tools to optimize report queries and improve data retrieval efficiency.
Mandatory skills:
Database Administration & Performance Optimization (SQL Server, indexing, query tuning, backups) Data Warehousing & ETL Management (SAGE DW, cubes, data extraction, ETL processes) Reporting & SQL Development (complex queries, stored procedures, automated reporting) System Monitoring & Troubleshooting (job monitoring, performance tracking, issue resolution) AI/ML & Advanced Analytics (anomaly detection, predictive analytics, AI-driven optimization & dashboards)
Optional Skills:
Python The pay range that the employer in good faith reasonably expects to pay for this position is $32.36/hour
56/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis. Tundra Technical Solutions is among North America's leading providers of Staffing and Consulting Services. Our success and our clients' success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.
Unincorporated LA County workers:
we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.