Database Administrator- Austin (TX)-Remote-C2c Need locals from austin
Posted 1 week ago by 1755752194
Negotiable
Outside
Remote
USA
Summary: The Database Administrator role focuses on managing and optimizing database systems, particularly within Azure and MDM environments. The position requires strong technical skills in database management, DevOps practices, and effective communication abilities. The candidate will work independently and collaboratively to meet business needs while ensuring system performance and reliability. This role is remote and emphasizes a deep understanding of various database technologies and practices.
Key Responsibilities:
- Perform computer systems analysis or development work related to database management.
- Coordinate, plan, and analyze user requirements to automate processes or improve existing systems.
- Manage and optimize databases, including backup, recovery, and security procedures.
- Implement DevOps practices, including CI/CD pipelines and automation.
- Collaborate with cross-functional teams to integrate database changes and resolve performance issues.
- Document processes and communicate technical details to non-technical stakeholders.
- Manage multiple projects and prioritize tasks effectively.
Key Skills:
- 4 years of experience in data warehouse aggregation and integration.
- 4 years of experience in assessing and improving existing databases.
- 4 years of working knowledge of data warehouse implementation processes.
- 4 years of experience with Enterprise Portal Applications.
- Strong communication skills for leading development activities and training.
- Experience with user journey mapping and application usability design.
- Proficiency in SQL and automation tools.
- Strong working knowledge of Azure services and MDM.
- Experience with Tableau Software, Power BI, and scripting in Python.
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Detailed Description From Employer:
Job Title: Database Administrator
Location: Austin, TX (Remote)
Duration: 12 Months
Location: Austin, TX (Remote)
Duration: 12 Months
Job Description:
The Database Administrator position requires knowledge of Azure, MDM Expertise, Azure Databricks, DevOps, Database Management, and development and automation.
The position requires an ability to communicate effectively, both verbally and in writing, and the ability to complete requests successfully against established timelines with limited supervision.
This position also requires the ability to learn and apply new technology, work independently or in a team environment, and collaborate with all levels of staff within DFPS to satisfy business needs.
The Worker is responsible for performing computer systems analysis or development work. Work involves coordinating, planning and analysis of user requirements, procedures, and problems to automate processing or to improve existing systems.
This role may also be responsible for the following:
We would like the Database Administrator to have the following skill sets and understanding:
Azure Expertise:
Deep understanding of Microsoft Azure services, particularly Azure SQL Database and other database offerings.
Experience with Azure DevOps, including CI/CD pipelines and automation.
Familiarity with Azure Resource Manager (ARM) templates, Azure CLI, and PowerShell scripting.
Azure Data Bicks Expertise:
Deep understanding of Azure data bricks and warehouse concepts
MDM Expertise:
Deep understanding of Informatica MDM and working with data profiling
DevOps Expertise:
Experience implementing DevOps practices, such as Continuous Integration/Continuous Deployment (CI/CD).
Understanding of version control systems (e.g., Git) and collaboration with development teams to integrate database changes seamlessly.
Experience with containerization and orchestration (e.g., Docker, Kubernetes).
Deployment exposure in the Salesforce and MuleSoft environment.
Database Management:
Proficient in database administration, maintenance, tuning, and optimization for Oracle, PostgreSQL, Sybase and other databases.
Knowledge of database backup, recovery, and disaster recovery procedures.
Experience in database security, including data encryption, authentication, and authorization.
Development and Automation:
Proficiency in Oracle and Postgres SQL and ability to write complex SQL queries and stored procedures.
Hands-on experience with automation tools and Infrastructure as Code (IaC) practices.
Ability to create, manage, and monitor database deployment and migration strategies.
Monitoring and Performance Tuning:
Familiarity with monitoring tools and performance analysis to optimize database performance.
Expertise in identifying and resolving database performance issues, such as bottlenecks and slow queries.
Soft Skills:
Problem-Solving: Strong analytical skills to diagnose and troubleshoot complex database issues.
Collaboration: Ability to work in a cross-functional team environment, collaborating with developers, system administrators, and other stakeholders.
Communication: Clear and effective communication skills to document processes and explain technical details to non-technical stakeholders.
Project Management: Ability to manage multiple projects and prioritize tasks effectively.
Required Skills:
4 years of experience in Data warehouse aggregation and integration of data across multiple applications.
4 years of experience in assessing existing databases and multiple information sources for the purpose of integrating existing data while improving data access, storage, data transparency and operational functions.
4 years of working knowledge of data warehouse end-to-end implementation processes, from business requirement logical modeling, physical database design, ETL, end-user tools, database, SQL, and performance tuning.
4 years of Enterprise Portal Application working knowledge.
4 years of excellent communication skills verbally and in writing used when leading development activities, presenting to leadership, and training less experienced developers.
3 years of experience with user journey mapping, storyboarding, creating mockups and wireframes, application usability design, fast prototyping, and proof-of-concept development.
2 years of performance management dashboard development.
Preferred Skills:
2 years of strong working knowledge of Tableau Software, Power BI, Power Apps, Oracle APEX.
2 years of strong working knowledge of Azure AD B2C, Azure ADF.
2 years of strong scripting experience using Python for data integration.
2 years familiarity with Informatica MDM, Informatica data Governance.
1 year of strong working knowledge of the following DFPS systems/programs (including but not limited to): IMPACT, ABCS.
1 year of technical Documentation including Design Documents, Standards, and Configuration Plans.
1 year of experience as a participant in agile software development teams.
1 year of experience with Federal, State, or Local government data reporting; with strong understanding of state government.
1 year of working knowledge of Web Content Accessibility Guidelines (WCAG) 2.0/Sec 508.
The Database Administrator position requires knowledge of Azure, MDM Expertise, Azure Databricks, DevOps, Database Management, and development and automation.
The position requires an ability to communicate effectively, both verbally and in writing, and the ability to complete requests successfully against established timelines with limited supervision.
This position also requires the ability to learn and apply new technology, work independently or in a team environment, and collaborate with all levels of staff within DFPS to satisfy business needs.
The Worker is responsible for performing computer systems analysis or development work. Work involves coordinating, planning and analysis of user requirements, procedures, and problems to automate processing or to improve existing systems.
This role may also be responsible for the following:
We would like the Database Administrator to have the following skill sets and understanding:
Azure Expertise:
Deep understanding of Microsoft Azure services, particularly Azure SQL Database and other database offerings.
Experience with Azure DevOps, including CI/CD pipelines and automation.
Familiarity with Azure Resource Manager (ARM) templates, Azure CLI, and PowerShell scripting.
Azure Data Bicks Expertise:
Deep understanding of Azure data bricks and warehouse concepts
MDM Expertise:
Deep understanding of Informatica MDM and working with data profiling
DevOps Expertise:
Experience implementing DevOps practices, such as Continuous Integration/Continuous Deployment (CI/CD).
Understanding of version control systems (e.g., Git) and collaboration with development teams to integrate database changes seamlessly.
Experience with containerization and orchestration (e.g., Docker, Kubernetes).
Deployment exposure in the Salesforce and MuleSoft environment.
Database Management:
Proficient in database administration, maintenance, tuning, and optimization for Oracle, PostgreSQL, Sybase and other databases.
Knowledge of database backup, recovery, and disaster recovery procedures.
Experience in database security, including data encryption, authentication, and authorization.
Development and Automation:
Proficiency in Oracle and Postgres SQL and ability to write complex SQL queries and stored procedures.
Hands-on experience with automation tools and Infrastructure as Code (IaC) practices.
Ability to create, manage, and monitor database deployment and migration strategies.
Monitoring and Performance Tuning:
Familiarity with monitoring tools and performance analysis to optimize database performance.
Expertise in identifying and resolving database performance issues, such as bottlenecks and slow queries.
Soft Skills:
Problem-Solving: Strong analytical skills to diagnose and troubleshoot complex database issues.
Collaboration: Ability to work in a cross-functional team environment, collaborating with developers, system administrators, and other stakeholders.
Communication: Clear and effective communication skills to document processes and explain technical details to non-technical stakeholders.
Project Management: Ability to manage multiple projects and prioritize tasks effectively.
Required Skills:
4 years of experience in Data warehouse aggregation and integration of data across multiple applications.
4 years of experience in assessing existing databases and multiple information sources for the purpose of integrating existing data while improving data access, storage, data transparency and operational functions.
4 years of working knowledge of data warehouse end-to-end implementation processes, from business requirement logical modeling, physical database design, ETL, end-user tools, database, SQL, and performance tuning.
4 years of Enterprise Portal Application working knowledge.
4 years of excellent communication skills verbally and in writing used when leading development activities, presenting to leadership, and training less experienced developers.
3 years of experience with user journey mapping, storyboarding, creating mockups and wireframes, application usability design, fast prototyping, and proof-of-concept development.
2 years of performance management dashboard development.
Preferred Skills:
2 years of strong working knowledge of Tableau Software, Power BI, Power Apps, Oracle APEX.
2 years of strong working knowledge of Azure AD B2C, Azure ADF.
2 years of strong scripting experience using Python for data integration.
2 years familiarity with Informatica MDM, Informatica data Governance.
1 year of strong working knowledge of the following DFPS systems/programs (including but not limited to): IMPACT, ABCS.
1 year of technical Documentation including Design Documents, Standards, and Configuration Plans.
1 year of experience as a participant in agile software development teams.
1 year of experience with Federal, State, or Local government data reporting; with strong understanding of state government.
1 year of working knowledge of Web Content Accessibility Guidelines (WCAG) 2.0/Sec 508.