Database Administrator - Houston, TX

Apply

Primary Purpose
The Database Administrator role is responsible for design, implementation, maintenance, and security of database management across Enterprise, in support of a comprehensive array of databases that support company business applications. This role will assist with the management and monitoring of enterprise database management systems, confirming that the systems are running efficiently and proactively preventing production issues. The Database Administrator is also responsible for enterprise-wide maintenance of databases and data environments, including performing version and patching upgrades. The role further includes the responsibility for building queries, stored procedures, database views and data models in support of Analytics and integration initiatives. The ideal candidate will have a background in database management, master data management, data analytics, computer science, or a related field with a desire to learn necessary business processes and procedures unique to the energy sector.

Duties and Responsibilities

Database Management and Governance:

• Maintains and manages enterprise-wide database footprint, including maintaining database inventory, version upgrades and security patches.
• Monitors database performance, ensuring maximum achievable up-time of production systems. Includes implementing logging and monitoring best practices.
• Maintains database backups and performs database restores and required.
• Ensures database supportability and applies best practice security posturing to database environments.
• Performs primary database support role, acting as L1 and L2 support. Responsible for performing root cause analysis when issues arise.
• Assists in the development and implementation of disaster recovery recommendations for company databases.
• Orchestrates all aspects of database change management, applying server resources and properly documenting as required to maintain and audit company data environments.
• Works cross functionally with other technology and business teams, providing database support as required to meet business needs.
• Participates in technology projects, performing functions such as database schema design, objectcreation and implementation.
• Performs activities related to Data movement/ETL.
• Configuration and maintenance of database user and role security.

Troubleshooting:

• Assists in timely resolution of issues in development, testing and production environments.
• Documents root cause analysis as required.

Collaboration:

• Work with cross-functional IT and enterprise teams to build alignment and model commitment to high performance as "one team"
• Communicates with IT Management, relevant to database performance and data management issues.
• Works collaboratively with the business, IT and Cyber Security to translate business needs into deliverable, data-related solutions.
• Communicates with all levels of management and end users across all activities performed, including maintenance, analysis, development, testing, and operational tasks.
• Provides status updates and communication of issue identification. Coordinates approvals as required to enable change.
• Presents production changes to IT & Cybersecurity Change Advisory Board
• Provides audit evidence upon request
• Drives the relationship and communications across business lines to ensure security is embedded withinsolutions

Performs other duties as assigned (no more than 5% of duties).

Qualifications

Education

• Bachelor's Degree Business Management, Computer Science, Information Systems, or equivalent relevant work experience

Experience

• 3 years work experience related to database engineering, master data management, data governance, data analytics, software engineering, platform engineering, computer science, information management

Skills and Abilities

Technical Skills:

• Use of SQL Server Management Studio and other tools required to support a SQL Server database environment. Experience maintaining enterprise database platforms.
• Ability to write T-SQL queries.
• Ability to integrate databases, using middleware and APIs.
• Support oriented: Ability to provide timely and quality support to our clients.
• Capable of performing root cause analysis when confronted with performance issues. Including ability to locate bottlenecks, monitor workload and throughput, review SQL performance and optimization, and manage DBMS resources.
• Ability to apply tools, methods, and practices to manage data-based assets along their lifecycle.
• Ability to perform database upgrades and safely/securely apply database patches.

Technical Knowledge:

• Up to date knowledge and in-depth understanding of the latest versions and capabilities of SQL Enterprise DBMS.
• Knowledge of SQL and interactions with common programing languages such as Python, JAVA, and C#.
• Understanding of data warehousing technology, including online analytical processing (OLAP) and star schema.
• Familiar with deployment and management cloud databases such as Microsoft SQL Azure.

Licenses and Certifications

• Certified in: Data Management Professional (CDMP), Governance of Enterprise IT (CGEIT) Preferred

HYBRID: Work a combination of onsite and remote days each week, typically 4 days per week onsite.

Information Technology

Full-time

Note: The Company strives to ensure that employees are paid equitably and competitively. Starting salaries may vary based on factors such as relevant experience, qualifications, and education.

Sempra Infrastructure offers a competitive total rewards package that goes beyond base salary. This position is eligible for an annual performance-based incentive (bonus) as well as merit-based recognition. Company benefits include health and welfare (medical, dental, vision), employer contributions to retirement benefits, life insurance, paid time off, as well as other company offerings such as tuition reimbursement, paid parental leave, and employee assistance programs.

Houston Center of Excellence-TXHS

Pay Range Pay Range

The estimated pay range for this job. Disclosing pay information promotes competitive and equitable pay.

The actual pay rate will depend on the person's qualifications and experience.

$99,000.00 - $148,500.00 / year

In order to support the Fair Compensation Strategy by the US Govt., HR Dept., clients are required to adhere to "Pay Transparency Law"; in the impacted states; that have mandated the employers to list the salary ranges in Job advertisements or postings for job opportunities and Job promotions.