What are the responsibilities and job description for the Technology Lead | Big Data | Oracle NoSQL position at Pyramid Consulting, Inc?
Immediate need for a talented Technology Lead | Big Data | Oracle NoSQL. This is a 03 months contract opportunity with long-term potential and is located in Alpharetta, GA(Onsite). Please review the job description below and contact me ASAP if you are interested.
Job ID:25-91155
Pay Range: $54 - $55/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).
Key Responsibilities:
Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, colour, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy [Link available when viewing the job].
#DelJ2W:CB3
Job ID:25-91155
Pay Range: $54 - $55/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).
Key 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
- Key Skills:[Software development, Oracle SQL, PL/ SQL and Unix, ETL]
- 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.
Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, colour, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy [Link available when viewing the job].
#DelJ2W:CB3
Salary : $54 - $55