Everest Consultants
Database Administrator 3
Everest Consultants, Portland, Oregon, United States, 97204
Title:
Database Administrator 3 Location: Portland, OR (Remote) Duration: 12-month Contract (with possible extensions up to 5 years) Pay Range: $62.58 - $80.00 per hour (Exact pay range will vary based on candidates location)
The role of the Database Administrator is to administer, test, and implement BPA management approved computer databases, applying knowledge of database management systems. Coordinates changes to computer databases. May plan, coordinate, and implement security measures to safeguard computer databases. The Database Administrator (DBA) may also perform enterprise level database administration using the Oracle tool suite to install databases, implement scripting, tuning, backups, monitoring, failover and data protection, recovery, security and integrity.
Position Responsibilities:
Test programs or databases, correct errors and make necessary modifications. Modify existing databases & database management systems or direct programmers and analysts to make changes. Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure. Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions. Train users and answer questions. Specify users and user access levels for each segment of database. Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems such as the installation of new databases. Review project requests describing database user needs to estimate time and cost required to accomplish project. Develop standards and guidelines to guide the use & acquisition of software and protect vulnerable information. Conduct performance tuning for servers, databases, and SQL Provide recommendations for process improvements and technical solutions that can be integrated into existing environments. Perform login management, install/patch, troubleshoot connectivity issues, monitor performance and tune when necessary, backup and restore databases in a complex three-tier architecture (client web interface, application engine, database engine). Write and debug PowerShell, VB and/or PERL scripts to automate DBA processes such as monitoring/alarming on volume growth, performance bottlenecks, batch scheduling, and connectivity failures. Utilize Windows-based tools and knowledge of Windows internals to troubleshoot, diagnose, and resolve performance and connectivity issues with Oracle on Windows. Recommend SAN-based storage configuration, such as disk layout, to improve performance. Provide developer and end-user support for databases including maintaining existing SQL and PL/SQL code and troubleshooting database interoperability problems Perform routine database management from command line without the use of GUI Tools. Install and maintain appropriate database fail-over solutions.
Position Requirements: Education & Corresponding Experience
bachelor's degree in information technology (or closely related technical discipline) is preferred. 10 years of experience is required with an applicable bachelor's degree. 15 years of experience is required without a degree or applicable degree. Experience should include directly related IT infrastructure administration. Required Technical Skills & Experience
10 years of knowledge and experience sufficient to administer MS SQL DB versions 2012 through 2022. 10 years of knowledge and experience sufficient to administer MS SQL Clustering/AlwaysOn. 5 years of knowledge and experience sufficient to successfully troubleshoot Windows operating systems using text-based logs, windows event logs, and various utilities as it pertains to support of SQL Database services. 5 years knowledge of and experience building tools for other administrators to use and automating operations with scripting tools such as shell scripting and PowerShell. 5 years of knowledge of and experience with TCP/IP and related services. Preferred Skills & Experience
Direct experience with supporting Azure SQL DB's. Direct experience managing SQL Server DB using Central Management Server (CMS) and Policy Based Management (PBM) and implementation of DISA STIG for SQL Server. Experience working with an enterprise scheduling system. Experience configuring and managing systems using Puppet Enterprise. Experience managing Oracle RDBMS.
Everest Consultants offers the following benefits for this position: medical, dental, & vision insurance, short-term disability, life and AD&D insurance, a 401(k) retirement plan, and a referral bonus program, paid sick/vacation/holidays, and a health and welfare fringe benefit.
Everest Consultants is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, national origin, age, disability, or any other characteristic protected by applicable local, state, or federal civil rights laws. #IND
Database Administrator 3 Location: Portland, OR (Remote) Duration: 12-month Contract (with possible extensions up to 5 years) Pay Range: $62.58 - $80.00 per hour (Exact pay range will vary based on candidates location)
The role of the Database Administrator is to administer, test, and implement BPA management approved computer databases, applying knowledge of database management systems. Coordinates changes to computer databases. May plan, coordinate, and implement security measures to safeguard computer databases. The Database Administrator (DBA) may also perform enterprise level database administration using the Oracle tool suite to install databases, implement scripting, tuning, backups, monitoring, failover and data protection, recovery, security and integrity.
Position Responsibilities:
Test programs or databases, correct errors and make necessary modifications. Modify existing databases & database management systems or direct programmers and analysts to make changes. Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure. Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions. Train users and answer questions. Specify users and user access levels for each segment of database. Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems such as the installation of new databases. Review project requests describing database user needs to estimate time and cost required to accomplish project. Develop standards and guidelines to guide the use & acquisition of software and protect vulnerable information. Conduct performance tuning for servers, databases, and SQL Provide recommendations for process improvements and technical solutions that can be integrated into existing environments. Perform login management, install/patch, troubleshoot connectivity issues, monitor performance and tune when necessary, backup and restore databases in a complex three-tier architecture (client web interface, application engine, database engine). Write and debug PowerShell, VB and/or PERL scripts to automate DBA processes such as monitoring/alarming on volume growth, performance bottlenecks, batch scheduling, and connectivity failures. Utilize Windows-based tools and knowledge of Windows internals to troubleshoot, diagnose, and resolve performance and connectivity issues with Oracle on Windows. Recommend SAN-based storage configuration, such as disk layout, to improve performance. Provide developer and end-user support for databases including maintaining existing SQL and PL/SQL code and troubleshooting database interoperability problems Perform routine database management from command line without the use of GUI Tools. Install and maintain appropriate database fail-over solutions.
Position Requirements: Education & Corresponding Experience
bachelor's degree in information technology (or closely related technical discipline) is preferred. 10 years of experience is required with an applicable bachelor's degree. 15 years of experience is required without a degree or applicable degree. Experience should include directly related IT infrastructure administration. Required Technical Skills & Experience
10 years of knowledge and experience sufficient to administer MS SQL DB versions 2012 through 2022. 10 years of knowledge and experience sufficient to administer MS SQL Clustering/AlwaysOn. 5 years of knowledge and experience sufficient to successfully troubleshoot Windows operating systems using text-based logs, windows event logs, and various utilities as it pertains to support of SQL Database services. 5 years knowledge of and experience building tools for other administrators to use and automating operations with scripting tools such as shell scripting and PowerShell. 5 years of knowledge of and experience with TCP/IP and related services. Preferred Skills & Experience
Direct experience with supporting Azure SQL DB's. Direct experience managing SQL Server DB using Central Management Server (CMS) and Policy Based Management (PBM) and implementation of DISA STIG for SQL Server. Experience working with an enterprise scheduling system. Experience configuring and managing systems using Puppet Enterprise. Experience managing Oracle RDBMS.
Everest Consultants offers the following benefits for this position: medical, dental, & vision insurance, short-term disability, life and AD&D insurance, a 401(k) retirement plan, and a referral bonus program, paid sick/vacation/holidays, and a health and welfare fringe benefit.
Everest Consultants is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, national origin, age, disability, or any other characteristic protected by applicable local, state, or federal civil rights laws. #IND