What are the responsibilities and job description for the SQL DBA position at Progilisys Solutions LLC?
Job Description
Complete Description
Direct Hire | In office only | Must be eligible to work in U.S. without Sponsorship
Our client is a Home builder located in Central Phoenix.
The Database Administrator (SQL DBA) is responsible for database planning, configuration, monitoring, optimization, and issue resolution. This role works independently on complex efforts, executing process steps, conducting analysis, problem solving, and delivering recommendations. Mastery of skills and knowledge of specialized work.
ESSENTIAL DUTIES & RESPONSIBILITIES
Administrates Cavco's databases, using various database management system tools to organize and store data.
Ascertains user requirements, creates computer databases, and tests and coordinates changes.
Interacts with development and end-user personnel to determine application data access requirements, transaction rates, volume analysis, and other pertinent data required to develop and maintain integrated databases.
Ensures performance of database.
Coordinates physical changes to computer databases; and codes, tests, and implements physical database, applying knowledge of database management system.
Designs logical and physical databases or reviews description of changes to database design to understand how changes to be made affect physical database; i.e., how data is stored in terms of physical characteristics, such as location, amount of space, and access method.
Establishes physical database parameters.
Codes database descriptions and specifies identifiers of database to database management system or directs others in coding database descriptions.
Calculates optimum values for database parameters, such as amount of computer memory to be used by database, following manuals.
Specifies user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data.
Specifies which users can access databases and what data can be accessed by user. • Tests and corrects errors, and refines changes to database.
Enters codes to create production database.
Selects and enters codes of utility program to monitor database performance, such as distribution of records and amount of available memory.
Directs programmers and analysts to make changes to data base management system.
Confers with co-workers to determine impact of database changes on other systems and staff cost for making changes to database.
Modifies database programs to increase processing performance, referred to as performance tuning.
Workers typically specialize in one or more types of database management systems. • May train users.
MINIMUM QUALIFICATIONS
Bachelors in Computer Science, Information Technology or related discipline
Masters in related field preferred
5 - 8 years' experience managing production databases in a large complex multi-tiered environment
Expert level of understanding with SQL Server and Oracle administration and troubleshooting.
Experience in supporting databases for critical systems with high uptime requirements.
Expertise with SQL Profiler (or alternate performance monitoring / troubleshooting tools)
Proficient with T-SQL.
Detailed knowledge of High Availability implementations (e.g. Windows Failover Cluster, "Always On" availability groups).
Experience with SQL Server Reporting Services (SSRS) configuration and administration
Familiarity with OLTP database design, theory and best practices.
Familiarity with automation techniques (Maintenance Plans, Powershell, etc.)
Excellent written and verbal communication skill
Direct Hire | In office only | Must be eligible to work in U.S. without Sponsorship
Our client is a Home builder located in Central Phoenix.
The Database Administrator (SQL DBA) is responsible for database planning, configuration, monitoring, optimization, and issue resolution. This role works independently on complex efforts, executing process steps, conducting analysis, problem solving, and delivering recommendations. Mastery of skills and knowledge of specialized work.
ESSENTIAL DUTIES & RESPONSIBILITIES
Administrates Cavco's databases, using various database management system tools to organize and store data.
Ascertains user requirements, creates computer databases, and tests and coordinates changes.
Interacts with development and end-user personnel to determine application data access requirements, transaction rates, volume analysis, and other pertinent data required to develop and maintain integrated databases.
Ensures performance of database.
Coordinates physical changes to computer databases; and codes, tests, and implements physical database, applying knowledge of database management system.
Designs logical and physical databases or reviews description of changes to database design to understand how changes to be made affect physical database; i.e., how data is stored in terms of physical characteristics, such as location, amount of space, and access method.
Establishes physical database parameters.
Codes database descriptions and specifies identifiers of database to database management system or directs others in coding database descriptions.
Calculates optimum values for database parameters, such as amount of computer memory to be used by database, following manuals.
Specifies user access level for each segment of one or more data items, such as insert, replace, retrieve, or delete data.
Specifies which users can access databases and what data can be accessed by user. • Tests and corrects errors, and refines changes to database.
Enters codes to create production database.
Selects and enters codes of utility program to monitor database performance, such as distribution of records and amount of available memory.
Directs programmers and analysts to make changes to data base management system.
Confers with co-workers to determine impact of database changes on other systems and staff cost for making changes to database.
Modifies database programs to increase processing performance, referred to as performance tuning.
Workers typically specialize in one or more types of database management systems. • May train users.
MINIMUM QUALIFICATIONS
Bachelors in Computer Science, Information Technology or related discipline
Masters in related field preferred
5 - 8 years' experience managing production databases in a large complex multi-tiered environment
Expert level of understanding with SQL Server and Oracle administration and troubleshooting.
Experience in supporting databases for critical systems with high uptime requirements.
Expertise with SQL Profiler (or alternate performance monitoring / troubleshooting tools)
Proficient with T-SQL.
Detailed knowledge of High Availability implementations (e.g. Windows Failover Cluster, "Always On" availability groups).
Experience with SQL Server Reporting Services (SSRS) configuration and administration
Familiarity with OLTP database design, theory and best practices.
Familiarity with automation techniques (Maintenance Plans, Powershell, etc.)
Excellent written and verbal communication skill
DBA Admin
Purple Drive Technologies -
Phoenix, AZ
Oracle DBA
Solugenix -
Phoenix, AZ
SQL Developer
Ascendion -
Phoenix, AZ