HCM Staffing and Consulting Group · 2 hours ago
Senior Database Administrator
Richardson, TX
Contract
Onsite
Senior Level
$67/hr - $72/hr
5+ years expHCM Staffing and Consulting Group is seeking a Senior Database Administrator to support the design, deployment, and operation of IT and OT solutions at a semiconductor manufacturing site. The role involves operational support of databases, development of high-availability solutions, and collaboration with cross-functional teams to optimize database technologies.
Bookkeeping and PayrollConsultingRecruitingStaffing Agency
Hiring Manager
Giardy Babila
Responsibilities
Operational support of on-premises databases spanning from equipment / process related through enterprise application related
Develop and deploy high-availability database solutions in MS SQL for manufacturing applications functions (MES, SCADA, Historian)
Ready to learn and support other database technologies (Oracle, DB2) -Migrate legacy reporting solutions to a data mart / data warehouse model
Design and implement advanced SQL procedures, views and develop dynamic SSRS/Power BI based reports (including drill-down, dashboards, and multi-parameter formats) to support complex analytics and reporting needs
Create and maintain processes and documentation for various database activities including architecture, user access, user termination, DB creation, DB migration, DB security, and Service Now knowledge etc
Mentor other team members in best practices and methods around DB queries and use
Troubleshoot performance issues related to virtualized and physical database workloads
Facilitate implementation of new technology stacks and migration of workloads from physical servers to virtualized instances wherever possible
Work with semiconductor process, equipment, and application vendors to continually evolve databases for the best performance and fault tolerance
Ensure 24 X 7 database monitoring and auditing tools are in place and effectively used. Participate in calls/meetings with site and corporate team members to address and troubleshoot application and database related issues impacting operations
Participate in daily tier meetings with factory systems and manufacturing operations teams
Work with Corporate IT and Global Security to maintain all databases to corporate and semiconductor cyber security standards
Qualification
Required
Bachelor's Degree
5+ years of hands-on experience with MS SQL
5+ years of experience with database tuning
5+ years of experience with SQL Server Management Studio
2+ years of experience with PowerShell scripting
3+ years of experience with SSRS
2+ years of experience with Power BI reporting
1+ years of experience with ServiceNow or another similar formal Service Management platform and/or methodology
Experience supporting IT/OT systems like MES, SCADA, or similar applications within manufacturing environments
Experience in all aspects of the software development lifecycle including requirements gathering, design, coding, testing and production support. Must demonstrate proficiency in documenting infrastructure, automation scripts, and system configurations to ensure clarity, maintainability, and operational continuity
Will support the design, deployment, and operation of cutting-edge IT and OT solutions at one of our most critical semiconductor manufacturing sites in Richardson, Texas
Collaborate with cross-functional teams to implement and optimize database technologies (MS SQL, Oracle), driving digital transformation and operational excellence across semiconductor manufacturing and business systems
Will also lead the transition from legacy reporting systems to a modern data architecture, implementing a robust data mart and data warehouse model to support advanced analytics and decision-making across the site
This site will be leveraging increasing AI based semiconductor centric automation, equipment integration, fault detection (FDC), and advanced process control (APC) solutions within manufacturing that will have this role deploying and supporting bleeding edge database platforms at all levels
Operational support of on-premises databases spanning from equipment / process related through enterprise application related
Develop and deploy high-availability database solutions in MS SQL for manufacturing applications functions (MES, SCADA, Historian)
Ready to learn and support other database technologies (Oracle, DB2) -Migrate legacy reporting solutions to a data mart / data warehouse model
Design and implement advanced SQL procedures, views and develop dynamic SSRS/Power BI based reports (including drill-down, dashboards, and multi-parameter formats) to support complex analytics and reporting needs
Create and maintain processes and documentation for various database activities including architecture, user access, user termination, DB creation, DB migration, DB security, and Service Now knowledge etc
Mentor other team members in best practices and methods around DB queries and use
Troubleshoot performance issues related to virtualized and physical database workloads
Facilitate implementation of new technology stacks and migration of workloads from physical servers to virtualized instances wherever possible
Work with semiconductor process, equipment, and application vendors to continually evolve databases for the best performance and fault tolerance
Ensure 24 X 7 database monitoring and auditing tools are in place and effectively used. Participate in calls/meetings with site and corporate team members to address and troubleshoot application and database related issues impacting operations
Participate in daily tier meetings with factory systems and manufacturing operations teams
Work with Corporate IT and Global Security to maintain all databases to corporate and semiconductor cyber security standards
Preferred
Advanced Degree preferably in Information Technology, Computer Science, or Computer Engineering
Experience with data protection, business continuity and disaster recovery options, configuration and execution
Experience with support of IT/OT systems and applications within manufacturing environments
Ability to effectively deal with critical outages and remediation efforts
The ability to translate issues / requirements and objectives into technical solutions
Strong knowledge of IT business processes and practices including ITIL methodology
The ability to be a change agent and promote positive change in the organization
Excellent oral, written and collaborative communication skills
Skilled in partnering with internal customers at all levels to define problems, identify solutions, and facilitate change
A self-starting, self-driven individual, working to remain motivated and efficient with minimum oversight
Company
HCM Staffing and Consulting Group
HCM Staffing and Consulting Group is a recruitment company that provides payroll services.
11-50 employees
H1B Sponsorship
HCM Staffing and Consulting Group has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2022 (2)
Funding
Current Stage
Early StageCompany data provided by crunchbase