Best analyticsllc.com
Baltimore, Maryland
Job Description The Senior Database Administrator (DBA) will work within a pool of other Senior DBAs to support approximately 20 online transaction processing (OLTP) applications, online analytical processing (OLAP) applications, and decision support systems (DSS). The database environment consists of databases that range in size from several hundred gigabytes (GB) to several terabytesized databases. The database management systems are both SQL Server and Oracle, so the successful applicant will have experience with both environments. The Senior DBA pool will support these applications in both a localDBA and centralDBA model. As the Local DBA, the candidate will directly provide all database services, including programming, tuning, design, etc. As the Central DBA, the candidate will operate as guidance and approval. As such, the candidate will need to be able to have excellent communication skills. Primary Responsibilities Analyze database requirements for OLTP and reporting and analysis applications. Responsible for the architecture of technical solutions for the databaserelated portions of IT projects. Design and construct databases. Develop methods for integrating different products such as customizing commercial databases to fit specific needs. Coordinate database development and determine project scope and limitations. Responsible for database provisioning and capacity planning for adequate database storage. Perform database backup and recovery using Oracle RMAN utility. Performing routine backups and restorations. Support Cloud Computation for Oracle/SQL Server databases. Perform data export and imports. Ensure integrity and recoverability of database structures. Responsible for database integrity of production databases. Develop operational procedures. Developing and implementing database administration policies & procedures including subsystem or instance security guidelines. Implement and maintain database structures and objects. Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software. Prepare and update documents of database standards, user manuals, procedures and processes, records, evaluations, schedule, project plans, reports, reviews, etc. Create and provide design artifacts for technical reviews of physical database models. Revise the company definition of data as defined in the data dictionary. Provide change management and documentation for database changes. Review periodic patches and new releases of Oracle software and implement the same in the CMS environment. Install and maintain a Real Application Cluster (RAC). Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems Install, configure, and maintain High Availability for Oracle databases. Migrate application data structures across multiple database platforms (such as SUN Solaris, IBM zLinux, MS Windows, etc.) Participating in database migration reviews. Migrate databases to different platforms, data centers, or AWS. Monitor and tune database environments for improved system performance. Provide query performance monitoring and tuning recommendations. Perform performance analysis and enhancement of SQL queries. Establish and calculate optimum values for database parameters, using manuals and calculators. Select and enter codes to monitor database performance and to create a production database. Responsible for the execution and monitoring of database utilities and scripts. Develop and test Oracle/SQL Server databases. Responsible for implementing or overseeing the implementation of all database programming. Develop and execute appropriate Data Definition Language (DDL) to support projects. Develop UNIX, Perl and other needed scripts to support applications and database administration functions. Test programs or databases, correct errors and make necessary modifications. Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions Provide guidance to database and application development personnel on the use and administration of Oracle and SQL Server DBMS software. Lead and conduct technical reviews of physical database models. Review project requests describing database user needs to estimate time and cost required to accomplish the project. Review procedures in database management system manuals for making changes to the database. Review and approve applicationbased scripts, utilities, stored procedures, functions, and triggers. Maintain quality of Oracle/SQL Server databases. Responsible for the databaserelated production release of project solutions. Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure. Specify users and user access levels for each segment of the database. Responsible for the security and integrity of the database environment. Maintain database control standards for central database administrators. Review physical data models submitted in a CMSapproved format (currently: CA AllFusion) for design integrity and adherence to published CMS database standards. Utilize management tools (e.g. Service Now) to support database users service requests. Provide user support for data and databaserelated issues. Train users and answer questions. The scope of the services requires support during core and noncore hours. Core hours are 6 AM to 9 PM eastern time (ET). Noncore hours include the following categories of support: Emergency This is offhours (noncore hours) support for database problems such as database crashes, backup failures, slow performance etc.; and Scheduled (this includes upgrades and releases). Planned support for work that cannot be conducted during core work hours. Oncall support during noncore hours on a rotational basis. " Required Qualifications A Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline or a commensurate combination of a relevant degree and 15 years total experience. Oracle certification is preferred. Experience working in the database domain with at least 10 years of experience managing all operations of Oracle and SQL Server databases. Demonstrated skills in both Oracle and SQL Server Area of Expertise Tools / DBMS Features: Oracle 19c, Oracle 12cR2, Oracle Real Application Cluster (RAC) (1,2 Node), Structured Query Language (SQL), Oracle PL/SQL, SQL PLUS, PL/SQL, TSQL, Linux and Windows Sysadmin skills, Shell Scripting (Bash/Korn/C shell), Oracle RMAN, Oracle SQL Loader, Oracle DataPump, Oracle +ASM, Symantec/Veritas NetBackup, OEM Cloud Control 13c, Oracle Automatic Workload Repository (AWR), Oracle Automatic Database Diagnostic Monitor (ADDM), Oracle Active Session History (ASH), OEM SQL Tuning Advisors, TOAD, Oracle SQL Developer, Erwin Data Modeler, CA AllFusion, MS SQL Server 2012/2016/2019, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SSIS Packages
Job Description The Senior Database Administrator (DBA) will work within a pool of other Senior DBAs to support approximately 20 online transaction processing (OLTP) applications, online analytical processing (OLAP) applications, and decision support systems (DSS). The database environment consists of databases that range in size from several hundred gigabytes (GB) to several terabytesized databases. The database management systems are both SQL Server and Oracle, so the successful applicant will have experience with both environments. The Senior DBA pool will support these applications in both a localDBA and centralDBA model. As the Local DBA, the candidate will directly provide all database services, including programming, tuning, design, etc. As the Central DBA, the candidate will operate as guidance and approval. As such, the candidate will need to be able to have excellent communication skills. Primary Responsibilities Analyze database requirements for OLTP and reporting and analysis applications. Responsible for the architecture of technical solutions for the databaserelated portions of IT projects. Design and construct databases. Develop methods for integrating different products such as customizing commercial databases to fit specific needs. Coordinate database development and determine project scope and limitations. Responsible for database provisioning and capacity planning for adequate database storage. Perform database backup and recovery using Oracle RMAN utility. Performing routine backups and restorations. Support Cloud Computation for Oracle/SQL Server databases. Perform data export and imports. Ensure integrity and recoverability of database structures. Responsible for database integrity of production databases. Develop operational procedures. Developing and implementing database administration policies & procedures including subsystem or instance security guidelines. Implement and maintain database structures and objects. Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software. Prepare and update documents of database standards, user manuals, procedures and processes, records, evaluations, schedule, project plans, reports, reviews, etc. Create and provide design artifacts for technical reviews of physical database models. Revise the company definition of data as defined in the data dictionary. Provide change management and documentation for database changes. Review periodic patches and new releases of Oracle software and implement the same in the CMS environment. Install and maintain a Real Application Cluster (RAC). Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems Install, configure, and maintain High Availability for Oracle databases. Migrate application data structures across multiple database platforms (such as SUN Solaris, IBM zLinux, MS Windows, etc.) Participating in database migration reviews. Migrate databases to different platforms, data centers, or AWS. Monitor and tune database environments for improved system performance. Provide query performance monitoring and tuning recommendations. Perform performance analysis and enhancement of SQL queries. Establish and calculate optimum values for database parameters, using manuals and calculators. Select and enter codes to monitor database performance and to create a production database. Responsible for the execution and monitoring of database utilities and scripts. Develop and test Oracle/SQL Server databases. Responsible for implementing or overseeing the implementation of all database programming. Develop and execute appropriate Data Definition Language (DDL) to support projects. Develop UNIX, Perl and other needed scripts to support applications and database administration functions. Test programs or databases, correct errors and make necessary modifications. Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions Provide guidance to database and application development personnel on the use and administration of Oracle and SQL Server DBMS software. Lead and conduct technical reviews of physical database models. Review project requests describing database user needs to estimate time and cost required to accomplish the project. Review procedures in database management system manuals for making changes to the database. Review and approve applicationbased scripts, utilities, stored procedures, functions, and triggers. Maintain quality of Oracle/SQL Server databases. Responsible for the databaserelated production release of project solutions. Plan, coordinate and implement security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure. Specify users and user access levels for each segment of the database. Responsible for the security and integrity of the database environment. Maintain database control standards for central database administrators. Review physical data models submitted in a CMSapproved format (currently: CA AllFusion) for design integrity and adherence to published CMS database standards. Utilize management tools (e.g. Service Now) to support database users service requests. Provide user support for data and databaserelated issues. Train users and answer questions. The scope of the services requires support during core and noncore hours. Core hours are 6 AM to 9 PM eastern time (ET). Noncore hours include the following categories of support: Emergency This is offhours (noncore hours) support for database problems such as database crashes, backup failures, slow performance etc.; and Scheduled (this includes upgrades and releases). Planned support for work that cannot be conducted during core work hours. Oncall support during noncore hours on a rotational basis. " Required Qualifications A Bachelor's Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline or a commensurate combination of a relevant degree and 15 years total experience. Oracle certification is preferred. Experience working in the database domain with at least 10 years of experience managing all operations of Oracle and SQL Server databases. Demonstrated skills in both Oracle and SQL Server Area of Expertise Tools / DBMS Features: Oracle 19c, Oracle 12cR2, Oracle Real Application Cluster (RAC) (1,2 Node), Structured Query Language (SQL), Oracle PL/SQL, SQL PLUS, PL/SQL, TSQL, Linux and Windows Sysadmin skills, Shell Scripting (Bash/Korn/C shell), Oracle RMAN, Oracle SQL Loader, Oracle DataPump, Oracle +ASM, Symantec/Veritas NetBackup, OEM Cloud Control 13c, Oracle Automatic Workload Repository (AWR), Oracle Automatic Database Diagnostic Monitor (ADDM), Oracle Active Session History (ASH), OEM SQL Tuning Advisors, TOAD, Oracle SQL Developer, Erwin Data Modeler, CA AllFusion, MS SQL Server 2012/2016/2019, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SSIS Packages