Apply on Employer Site

Pyramid Consulting, Inc · 2 months ago

Technology Lead | Big Data | Oracle NoSQL

Alpharetta, GA

Full-time

Onsite

Senior Level, Lead/Staff

$54/hr - $55/hr

8+ years exp

Pyramid Consulting, Inc is a leading IT Industry company, currently seeking a Technology Lead specializing in Big Data and Oracle NoSQL. The role involves analyzing data needs, developing databases, troubleshooting issues, and providing technical support for core infrastructure components.

ConsultingInformation TechnologyLegalProfessional ServicesSoftwareStaffing Agency

Growth Opportunities

H1B Sponsor Likely

Responsibilities

Works with stakeholders to analyze data needs, design or evaluate solutions and develop databases to meet business requirements

Troubleshoots and resolving database integrity issues, blocking and deadlocking issues, connectivity issues, and security issues

Troubleshoots Oracle related CPU, Memory, I/O, disk space and other resource contention

Manages encrypted databases

Conducts performance tuning, query optimization, using Performance Monitor, and other related monitoring and troubleshooting tools

Executes backups, restores, recovery models, and database maintenance tasks

Writes and troubleshoots SQL Code and designs (stored procs, functions, tables, views, triggers, indexes, constraints)

Documentations processes and procedures

Upgrades database from one SQL version to another SQL version

Provides technical support and coordination for core infrastructure components including server, network, storage, and software

Qualification

Oracle SQLPL/SQLUnixETLDatabase performance tuningPythonAnalytical skillsTroubleshooting skillsCustomer handling

Required

Minimum 8 years of experience in software development using Oracle SQL, PL/ SQL and Unix

Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages and Exceptions

Knowledge of Python would be an added advantage

Expertise in database performance tuning and Unix programming

Experience in data replication within Oracle and Oracle to other DB

Knowledge on Golden Gate and QLIK replication software

Good experience in developing Programs to import data from various sources into Oracle Database tables using PL/SQL, SQL*Loader

Experience with ETL process for Data loading from oracle to Data Warehouse

Having good experience in deployments and production support of developed applications

Also having customers handling experience

Strong Analytical, Diagnostic and Troubleshooting skills and ability to work in a dynamic, team-oriented environment

Hands-on experience in oracle database design and modeling and query tuning

Benefits

Health insurance (medical, dental, vision)

401(k) plan

Paid sick leave (depending on work location)

Company

Pyramid Consulting, Inc

Glassdoor4.2

Pyramid Consulting, a global leader in workforce and technology solutions, empowers individuals and organizations to transform and thrive in the most challenging and competitive markets.

Founded in 1996

Alpharetta, Georgia, USA

5001-10000 employees

https://pyramidci.com/

H1B Sponsorship

Pyramid Consulting, Inc has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (178)

2024 (112)

2023 (95)

2022 (62)

2021 (50)

2020 (117)