SQL Database Administrator ( GCS / PCS Operations & Maintenance)

DOOTA INDUSTRIAL AMERICA LLC•Austin, TX

just now

About The Position

This role is responsible for daily monitoring and support of GCS, PCS, and related systems to ensure high availability, data integrity, and life-safety–critical reliability. The position serves as the first-line responder for alarms and incidents, manages tickets and system changes, supports PCS drivers and industrial communications, and follows formal change management procedures. The role also focuses on preventive maintenance, continuous improvement, documentation, reporting, and cross-functional coordination to minimize risk, meet SLAs, and maintain stable operations. Join Doota Industrial America and be part of a thriving company that values safety, professional growth, and collaboration. Embark on an exciting career journey and make a tangible impact on the lives of those around you. Who We Are Embark on an exhilarating journey with Doota Industrial America, where we unite forward-thinking pioneers driven by a passion for innovation. We are expanding our dynamic teams with individuals eager to collaborate, build communities, and shape a brighter future together. Our doors are open to candidates from all walks of life, with diverse experiences, skill sets, and backgrounds, as we embrace the power of inclusion and diversity in our work culture. Founded in South Korea in 2002, Doota IT has since been operating in over 50 customer sites worldwide. With our Round Rock office launching in 2019 we have the ability to offer the best of both worlds: the agility of a start-up and the stability of an enterprise. We are most proud of being recognized by the South Korean Prime Minister for our contributions to commerce and industry growth, positioning us as an industry leader. Join forces with esteemed partners such as Samsung, LG, HP, SK Innovation, and Hyundai as we continue to make strides in the realm of environmental CEMS, encompassing design, measuring instrument delivery and installation, datalogger, FEP, monitoring systems, and CEMS room construction. At Doota Industrial America, we foster a vibrant environment that nurtures creativity, collaboration, and professional growth. As part of our family, you will have access to resources and support that empowers you to excel. Our commitment to culture, integrity, and continuous improvement lies at the core of our mission, propelling us to transcend industry boundaries and make lasting, positive impacts on the world. With Doota Industrial America, the sky is the limit. Join us and take part in crafting the future. Your extraordinary journey begins now!

Requirements

Strong operational experience with monitoring and control systems.
Hands-on experience with:• Relational databases, with a strong emphasis on Oracle and/or MS SQL• Writing, analyzing, and troubleshooting SQL queries• Understanding database schemas, table relationships, and data flows• Investigating system issues through data analysis, queries, and historical records
Operational experience in:• Linux-based environments (basic shell usage and log inspection)• Analyzing logs, alarms, trends, and system metrics to identify root causes• Supporting production systems where database integrity and availability are critical
Ability to:• Quickly understand existing database structures and system data models• Trace how data moves between systems, services, and monitoring components• Assess the operational impact of data anomalies, missing records, or performance degradation
Familiarity with application-level technologies such as:• .NET, C#, Java, or similar languages (for reading logs or understanding system behavior)• Basic understanding of UI or scripting technologies (e.g., JavaScript) is a plus, but not required
3–10+ years of experience in operations, maintenance, or systems engineering within:Semiconductor manufacturing, Industrial automation, Mission-critical or life-safety systems
Demonstrated ability to operate under defined SLAs and escalation models.
Strong analytical, troubleshooting, and documentation skills.
Ability to work independently while coordinating across multiple cross-functional teams.
Clear communication skills for incident reporting, governance reviews, and client interaction.

Nice To Haves

Basic understanding of UI or scripting technologies (e.g., JavaScript) is a plus, but not required

Responsibilities

Perform daily health checks and operational monitoring of GCS 1.0 / GCS 2.0, iEES / FMCS interfaces, iQMS infr a structure, iPCS monitoring and PCS drivers
Monitor system performance across Buffer, Web, Application, IO, and Database servers.
Review logs, alarms, events, barcode history, and interface transmission status to detect abnormalities.
Ensure uninterrupted data integrity and system availability (target uptime = 99.99%).
Act as first-line responder for GCS / PCS alarms, communication failures, and abnormal system behavior.
Perform rapid troubleshooting and recovery actions for Equipment communication errors, PCS driver failures, Interface disruptions (iEES, FMCS, Infra-EES)
Support emergency response activities during off-shift, night shift, and maintenance windows.
Participate in incident investigations, including Root cause analysis (RCA), 8D report creation and follow-up, Countermeasure development and deployment
Manage and respond to support tickets and VOCs involving Tag / parameter add, change, delete, Equipment add / change / removal, IO mapping updates, UI, buffer, AP, DB, barcode, and interface issues
Validate requests, define corrective actions, execute standard activities, and escalate non-standard items per governance.
Maintain accurate documentation and activity records in designated management systems.
Perform daily inspections and maintenance of PCS drivers (~300+ assets).
Manage PCS driver configuration, firmware updates, IP and communication settings.
Troubleshoot industrial communication protocols including RS232 / RS485 / Ethernet, Modbus, Omron, OPC
Coordinate with PCS, Network, and equipment teams to resolve persistent or systemic issues.
Execute change point activities in compliance with governance-defined MOC procedures.
Support pre- and post-change monitoring (Day 1 / Day 3 / Day 7 verification).
Prepare and review release documentation, checklists, and impact assessments.
Validate system behavior following hardware, software, or infrastructure upgrades.
Proactively identify weak points, recurring issues, and performance degradation trends.
Support system standardization initiatives (e.g., GCS 2.0 standard compliance).
Develop and update SOPs, operational runbooks, and standardized checklists.
Implement automation and monitoring enhancements where applicable.
Prepare and submit required reports, including Daily and weekly operational status reports, Off-shift support summaries, Changepoint summaries with evidence, KPI performance tracking
Participate in weekly operations meetings and quarterly business reviews.
Coordinate closely with IT Strategy & Mobile / Information Management teams, Facilities Operations, Network, ECA, GCS, PCS, and equipment engineering teams
Escalate system risks, SLA impacts, and out-of-scope requests as required.