Required Skills: Certifications in Azure Data Factory or Informatica, ETL processes and data integration methods, Oracle Cloud RDBMS and Salesforce CRM ,PERL Scripts, Tableau dashboards
Job Description
Seeking a highly skilled and experienced Database Administrator (DBA) to support our client in Austin, Texas.
The ideal candidate will be responsible for the planning, development, implementation, maintenance, and performance tuning of integrated database systems in a complex, enterprise environment. This includes logical and physical data modeling, implementing performance enhancements, ensuring data security and accessibility compliance, and working collaboratively with application and infrastructure teams to optimize database solutions.
Job Location: Austin, Texas (Hybrid Mondays and Fridays Onsite)
Please Note: Program will only allow candidates who are LOCAL TO THE AUSTIN AREA ONLY (Within 50 mile radius).
Key Responsibilities:
- Create, modify, and maintain production databases and related applications.
- Use utility programs to monitor and optimize database performance, including storage distribution and memory usage.
- Direct and collaborate with developers and analysts to implement changes to database systems.
- Review, debug, and correct database-related programs and procedures.
- Answer user inquiries and provide technical support for database access and use.
- Evaluate and incorporate users’ requests for new data elements or changes into the existing data environment.
- Coordinate database changes to assess their impact on other systems and operational costs.
- Implement performance tuning for optimal data processing.
- Maintain data integrity, minimize redundancy, and ensure consistency across databases.
- Perform logical and physical data modeling using tools like Tableau, Azure Data Factory (ADF), and Informatica.
- Design and implement database solutions in Oracle Cloud RDBMS and Salesforce CRM environments.
- Create and maintain Entity Relationship Diagrams (ERDs) and generate scripts using data modeling tools.
- Develop stored procedures, database triggers, and complex PL/SQL packages.
- Write and maintain source-to-target mapping documents for ETL processes.
- Execute database recovery and backup procedures.
- Maintain a data dictionary and enforce data standards across systems.
- Assist in the installation and configuration of database software and participate in disaster recovery planning.
- Ensure compliance with EIR Accessibility standards, especially for user interfaces involved in data entry, access, and reporting.
- Collaborate with IT, development, and operations teams to gather requirements and deliver database solutions.
- Stay updated on best practices and emerging trends in database technologies and accessibility.
Required Skills and Qualifications:
Bachelor’s degree in Computer Science, Information Systems, or related field. Equivalent experience may be considered in lieu of a degree.
Minimum 7 years of experience in:
- Evaluating and implementing user data requests.
- Installing and using data modeling tools (e.g., Tableau, ADF, Informatica).
- Developing logical/physical data models and ERDs.
- Working with Oracle Cloud RDBMS and Salesforce CRM.
- Designing and maintaining production database models.
- Creating scripts from modeling tools.
- Managing changes to data model designs.
- Writing source-to-target mappings for ETL.
- Developing PL/SQL stored procedures, triggers, and packages.
- Performing data analysis and providing mapping guidance to development teams.
Preferred Skills and Qualifications:
5 years of Experience in:
- Coordinating across cross-functional teams.
- Working under limited supervision with independent judgment.
- Applying creative problem-solving approaches.
At least 4 years of Experience in:
- Communicating effectively with stakeholders and team members.
- Familiarity with industry-standard database management concepts and practices.
2 years of Experience in:
-
Working knowledge of ETL processes and data integration methods.
-
Experience working with PERL scripts.
-
Experience in creating and maintaining Tableau dashboards.
-
Certifications in Azure Data Factory or Informatica.