Database Administrator

Exciting • Phoenix, AZ

14d

About The Position

The Database Administrator is responsible for database management system software and tools. Knowledge of logical database schema to investigate problems and collect performance statistics and create reports. They carry out routine configuration/installation and reconfiguration of database and related products to achieve business performance and scalability standards. Additionally, the role will serve as a product owner for databases and the operating systems including life cycle roadmaps for releases, and upgrades. What you will do here: Perform routine configuration/installation and reconfiguration of database and related products. Take responsibility for the accessibility, retrievability and security of specific subsets of database and indexing. Support the monitoring, health, performance, and availability on Microsoft SQL and PostgreSQL development and production databases. Support Server/Database management, migrations, removals, archives and manage data purge processes on production and development databases. Monitor production SSIS packages, troubleshoot failures and re-run as necessary or escalate for additional development, assist with production deployments / changes Perform SQL query code reviews and query performance tuning using database analyzation tools. Develop reporting solutions using custom tables and views normalizing disparate data sources. Support the iterative performance tuning of database environments, ETL processes and SQL queries as needed. Provide upgrades and release as needed per the life cycle management roadmaps Develops and maintains specialist knowledge of database concepts, object and data modelling techniques and design principles and a detailed knowledge of database architectures, software and facilities Perform other job-related duties as assigned.

Requirements

• Bachelor's degree in Information Technology, Information Systems, engineering ore related field preferred or equivalent combination of education and experience required.
• 2+ years of experience supporting Database Administration required.
• Enterprise Data Center experience supporting mission critical, 24x7, Highly Available (HA), and Disaster Recovery (DR) database architectures required.
• Demonstrated knowledge of data management practices and database administration processes required.
• Demonstrated experience with support design and management of relational databases with multiple RDBMS vendors (SQL and PostgreSQL) required.
• Demonstrated knowledge of database backup, recovery strategy, database performance management and tuning required.
• Expertise in SQL Server monitoring to ensure timely alerts and minimized false alarms required.
• Excellent analytical, mathematical, and creative problem-solving skills required.
• Excellent listening, interpersonal, written and oral communication skills required.
• Ability to effectively prioritize and execute tasks while under pressure required.
• Strong customer service skills required.
• Ability to interact effectively and collaboratively within a team environment required.

Nice To Haves

• Microsoft SQL Certifications- MCP, MCITP, MCTS preferred.

Responsibilities

• Perform routine configuration/installation and reconfiguration of database and related products.
• Take responsibility for the accessibility, retrievability and security of specific subsets of database and indexing.
• Support the monitoring, health, performance, and availability on Microsoft SQL and PostgreSQL development and production databases.
• Support Server/Database management, migrations, removals, archives and manage data purge processes on production and development databases.
• Monitor production SSIS packages, troubleshoot failures and re-run as necessary or escalate for additional development, assist with production deployments / changes
• Perform SQL query code reviews and query performance tuning using database analyzation tools.
• Develop reporting solutions using custom tables and views normalizing disparate data sources.
• Support the iterative performance tuning of database environments, ETL processes and SQL queries as needed.
• Provide upgrades and release as needed per the life cycle management roadmaps
• Develops and maintains specialist knowledge of database concepts, object and data modelling techniques and design principles and a detailed knowledge of database architectures, software and facilities
• Perform other job-related duties as assigned.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level