Orangegrid - Flower Mound, TX
posted 22 days ago
As a Database Administrator, you will manage, develop, refactor, and optimize database operations to support Online Transaction Processing (OLTP), reporting, and Extract, Transform, Load (ETL) processes within a Business-to-Business (B2B) environment. This role leverages a suite of Software-as-a-Service (SaaS) solutions, primarily utilizing Microsoft products. You will be expected to analyze and evaluate reported problems, take responsibility for their resolution, and implement measures to prevent recurrence. Your responsibilities will include developing, testing, implementing, troubleshooting, and supporting data extraction, transformation, and loading processes. You will maintain database performance by calculating optimum values for database parameters, implementing new releases, and completing maintenance requirements. Additionally, you will install revised or new systems by proposing specifications and flowcharts, recommending optimum access techniques, and coordinating installation requirements. Proactive management of database performance tuning and optimization will be a key aspect of your role, along with developing and implementing database business continuity plans and procedures. You will create new databases, tables, views, indexes, scheduled jobs, triggers, and logins based on system specifications, and tune data warehouses and other database systems for optimal performance and reliability. Your role will also involve performing index and statistics maintenance, developing, implementing, administering, and maintaining operational automation scripting, and maintaining technical documentation related to the database systems and processes. You will provide after-hours and weekend escalation support as required, coach, train, and mentor other employees on proper access and use of database systems, and adhere to Scrum principles and philosophies in fulfilling your role. Collaboration across teams and business areas in an Agile setting will be essential, as will reporting and managing risks identified within your work area, including Information Security risks.