What are the responsibilities and job description for the Database Administrator position at Phoenix Staff, Inc.?
Title: Database Administrator (DBA)
Location: Scottsdale, AZ or Anchorage, AK; hybrid
Type: 3 month Contract-to-Hire
Your role:
- Engineer and manage database systems to ensure optimal performance, security, and stability.
- Conduct routine database upkeep, including data backups, index optimization, software patching, license administration, and version upgrades.
- Analyze and enhance database performance, addressing bottlenecks and inefficiencies to ensure smooth operation.
- Implement and oversee access controls, encryption, and data protection measures to maintain database security and regulatory compliance.
- Diagnose and resolve database-related problems to ensure business continuity.
- Oversee and fine-tune cloud-based database environments within platforms like Oracle PaaS and Azure, including configuration, scaling, and performance optimization.
- Administer on-premises database instances, servers, and supporting infrastructure to guarantee uninterrupted service and minimize downtime.
- Set up, monitor, and maintain operating systems and server hardware that support database environments.
- Work closely with IT teams to align database environments with overall system architecture and business needs.
- Create and maintain scripts to automate administrative tasks, such as build deployments and system monitoring.
- Develop and implement disaster recovery and business continuity strategies for database systems.
- Provide support for database compliance and regulatory audits as required.
- Serve as a technical expert for IT, business teams, and occasionally clients, understanding their data analytics needs, application requirements, challenges, and data integration goals.
- Analyze, document, and clearly communicate technical and functional requirements related to databases, data processes, data quality, and data governance.
- Guide and assist application development teams in database schema design and query optimization.
- Support data analytics teams in the creation and execution of data models, dashboards, and reports.
- Provide expertise in data integration processes, including ETL workflows and API/file-based data interfaces.
- Collaborate with application development teams to ensure database integration with software development lifecycle (SDLC) processes.
- Contribute to the design, testing, and deployment of applications by offering database-related insights and recommendations.
- Guarantee effective management of database changes within version control and deployment pipelines.
- Develop scripting solutions using languages like PowerShell, Python, or SQL, and participate in code reviews with a focus on SQL and database design best practices.
- Support the integration of database systems within Agile and DevOps workflows.
- Work with stakeholders to establish data governance standards and best practices.
- Provide training and support to team members on database systems and tools.
- Collaborate with cross-functional teams to implement and improve data-driven solutions.
- Maintain comprehensive documentation of database environments, architecture diagrams, configurations, and procedures.
What you've got:
- Bachelor's degree in Computer Science, Information Technology, or a similar field.
- 5 years of experience as a Database Administrator with experience in system administration.
- 3-4 years of experience with web services, RESTful services (JSON and XML), database management, and SQL development.
- Proficiency in database platforms like SQL Server, Oracle, or ETL tools like Databricks.
- Solid understanding of system administration, including Linux/Windows servers and virtualization.
- Practical experience with cloud platforms such as Oracle Cloud Infrastructure or Azure.
- Proficiency in scripting languages like Python or PowerShell.
- Familiarity with data integration tools and techniques, such as Azure Synapse, Microsoft Fabric, Oracle Integration Cloud, Databricks, or custom ETL pipelines.
- Excellent communication and interpersonal skills, with a proven ability to collaborate effectively with both technical and non-technical stakeholders.
- Strong problem-solving and analytical skills, including experience using data to inform decisions and independently resolve software engineering challenges.
Preferred:
- Certification in database administration such as Microsoft SQL Server, Oracle DBA.
- Experience with DevOps tools like Docker, Kubernetes, or CI/CD pipelines.
- Understanding of Agile methodologies and project management practices.
- Experience with application integration platforms and/or data analytics platforms (e.g., Oracle Integration Cloud, data lake solutions, data mart & warehouse solutions, Databricks data storage and orchestration solutions) or related experience such as software development management positions.
- Background in Oracle Fusion ERP/HCM, Oracle Autonomous Data Warehouse, Oracle Integration Cloud, Power BI, Power BI Server, and Power Apps.
To find more great tech-centric jobs, please visit www.phoenixstaff.com.
Salary : $38 - $50