Specialist DBA - Big Data

3 Key Consulting, Inc.

(Thousand Oaks, California)

Full Time

Job Posting Details

About 3 Key Consulting, Inc.

3 Key Consulting is an advisory, technology and staff augmentation services provider, with over 20 years of experience in IT and IT enabled business solutions to Fortune 500 companies. 3KC has a mature business intelligence practice with expertise in data warehousing, data integration, data analytics and data governance.

Summary

3Key Consulting Inc. is looking for a Specialist DBA for a leading bio-pharmaceutical company in Thousand Oaks CA TO Support DB related projects in 2016, Level3 DB support, Automation Projects, BIG DATA & NoSQL environment support

Responsibilities

**Day to Day Responsibilities/First 30 Days:**

- Support of existing RDMBS infrastructure, and application DB analysis and tuning 
- Working with Automation team to build DB related self-service components (DB provisioning, Patching, Accounts, Storage, etc…) 
- Architecting, Documenting & Configuring NoSQL environments

**Job Responsibilities:**

* Implement & configure Oracle software ((DBMS, Oracle Tools, Oracle Web, networking software’s (e.g. SQLNET, Oracle Names)) 
* Implement & configure DB appropriate to business requirements (OLTP, decision support, standby DB, replication) 
* Set up Database tools and scripts to proactively monitors databases and send alerts to enable the DBAs to reduce outages 
* Create and generate various database reports to help plan for capacity and performance. 
* Investigates and resolves technical database issues. 
* Performs analysis and determination of database performance characteristics, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities for multiple applications. Recommends and implements SQL tuning opportunities toto improve system response and run times. 
* Defines logical attributes and data inter-relationships and designs data structures to accommodate database implementation, storage, maintenance and accessibility to enhance performance. 
* Develops and documents standards, procedures, work instructions for database support that help in increased productivity for operations. 
* Optimizes database accessibility by developing load balancing architectures and processes to eliminate down time for backup processes. 
* Implements and supports database security regulations, policies, and guidelines. Monitors security bulletins to obtain information of potential threats; installs necessary security patches to ensure ongoing database security. 
* Functions as a technical project leader or provides work leadership for less experienced personnel on a portfolio of databases, including installations and upgrades of DBMS software and backup/recovery strategies. Reviews and approves application and database design decisions to ensure that application solutions exhibit high levels of performance, security, scalability, maintainability, and reliability upon deployment. 
* As need be, manage and develop team members/partners 
* Serve as the primary interface for the business to interact with all IS services 
* Identify and remove barriers by working with internal and external stakeholders 
* Prioritize workload in accordance with goals 
* Accountable for all audit and security compliance issues (Amgen & government regulations). 
* Create Scripts within SQL and unix 
* Participate in Root Cause Analysis reviews when applicable. 
* New technologies: POC, design, architect, document, and implement new solutions in the DB landscape.

* Primarily responsible for administering and managing databases supporting custom and commercially developed applications. Design, implement and maintain complex database/system solutions
* Responsibilities may include installation, upgrades and optimization, backup/recovery, access control administration, database vendor contract administration, disaster recovery support, performance monitoring, development and test environment support, documentation, and infrastructure and methodologies improvements.

Day to Day Responsibilities/First 30 Days:

Support of existing RDMBS infrastructure, and application DB analysis and tuning
Working with Automation team to build DB related self-service components (DB provisioning, Patching, Accounts, Storage, etc…)
Architecting, Documenting & Configuring NoSQL environments

Job Responsibilities:

Implement & configure Oracle software ((DBMS, Oracle Tools, Oracle Web, networking software’s (e.g. SQLNET, Oracle Names))
Implement & configure DB appropriate to business requirements (OLTP, decision support, standby DB, replication)
Set up Database tools and scripts to proactively monitors databases and send alerts to enable the DBAs to reduce outages
Create and generate various database reports to help plan for capacity and performance.
Investigates and resolves technical database issues.
Performs analysis and determination of database performance characteristics, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities for multiple applications. Recommends and implements SQL tuning opportunities toto improve system response and run times.
Defines logical attributes and data inter-relationships and designs data structures to accommodate database implementation, storage, maintenance and accessibility to enhance performance.
Develops and documents standards, procedures, work instructions for database support that help in increased productivity for operations.
Optimizes database accessibility by developing load balancing architectures and processes to eliminate down time for backup processes.
Implements and supports database security regulations, policies, and guidelines. Monitors security bulletins to obtain information of potential threats; installs necessary security patches to ensure ongoing database security.
Functions as a technical project leader or provides work leadership for less experienced personnel on a portfolio of databases, including installations and upgrades of DBMS software and backup/recovery strategies. Reviews and approves application and database design decisions to ensure that application solutions exhibit high levels of performance, security, scalability, maintainability, and reliability upon deployment.
As need be, manage and develop team members/partners
Serve as the primary interface for the business to interact with all IS services
Identify and remove barriers by working with internal and external stakeholders
Prioritize workload in accordance with goals
Accountable for all audit and security compliance issues (Amgen & government regulations).
Create Scripts within SQL and unix
Participate in Root Cause Analysis reviews when applicable.
New technologies: POC, design, architect, document, and implement new solutions in the DB landscape.
Primarily responsible for administering and managing databases supporting custom and commercially developed applications. Design, implement and maintain complex database/system solutions
Responsibilities may include installation, upgrades and optimization, backup/recovery, access control administration, database vendor contract administration, disaster recovery support, performance monitoring, development and test environment support, documentation, and infrastructure and methodologies improvements.

Ideal Candidate

Expertise in Oracle RDBMS 12c and Oracle Technologies (Oracle RAC, DataGuard, Exadata, Pluggable DBs, OEM, etc…)
Coding Skills (Python, Javascripting, .Net, Perl, etc…), & Automation expertise
Skills in NoSQL space - Hadoop, Mongo, Cassandra, Spark, Solr, and other NoSQL databases
Red Flags: Being an expert in all areas, especially BIG DATA

Similar Jobs

See other jobs at 3 Key Consulting, Inc.
See more information technology jobs in California