smartShift Technologies is looking for a seasoned Database Administrator - Oracle to join our Bangalore team.
Responsibilities
- Perform regular Database administration tasks.
- Perform HA and DR setup maintenance tasks
- Analyze the performance metrics and provide tuning recommendations
- Analyze the repetitive support requests and provide the automation feasibility
- Handle incidents and problems
- Perform trend analysis of the incidents/events and help in finding the resolution
Skills & Experience
- Strong experience in Database Administration in Oracle database
- Have strong knowledge on Oracle SQL and PL/SQL
- Expertise in writing and analysing Stored procedure , packages and triggers.
- Exposure to AWS Cloud RDS is required
- Experience in Database Patching/Upgrade/Migrations
- Experience in managing the HA and DR setups ( Standby, DataGuard)
- Experience in performance tuning ,query optimisation
- Experience with client interaction is preferred
- Exposure to other MySQL database is preferred
- Excellent written and verbal communication skills.
- Real time experience in DB administration (Installation/Tablespace Management/Object Management
- Expertise in RMAN and other backup(Expdp/Impdp) methodology implementations
- Experience in Database Patching/Upgrade/Migrations
- Knowledge on GoldenGate is desirable
- Knowledge on Oracle 12C/19C new features
- Experience with client interaction is preferred
- Knowledge on RAC & ASM is desirable
- Exposure to AWS Cloud is desirable
- Excellent written and verbal communication skills

About smartShift Technologies
About
Connect with the team
Similar jobs
Minimum 5-10 years of experience in database development or a related field. Proven experience with database design, development, and management. Experience working with large-scale databases and complex data environments.
Experience with data modelling and database design. Knowledge of database performance tuning and optimization. Architect, Develop and maintain tables, views, procedures, functions and packages in Database
Performing complex relational databases queries using SQL (AWS RDS for PostgreSQL) and Oracle PLSQL
Familiarity with ETL processes and tools (AWS Batch, AWS Glue etc)
Familiarity with CI/CD Pipelines, Jenkins Deployment, Git Repository
Perform in performance tuning. Proactively monitor the database systems to ensure secure services with minimum downtime and improve maintenance of the databases to include rollouts, patching, and upgrades. Experience with Aurora's scaling and replication capabilities.Proficiency with AWS CloudWatch for monitoring database performance and setting up alerts. Experience with performance tuning and optimization in AWS environments
Experience using Confluence for documentation and collaboration. Proficiency in using SmartDraw for creating database diagrams, flowcharts, and other visual representations of data models and processes.Proficiency in using libraries such as Pandas and NumPy for data manipulation, analysis, and transformation. Experience with libraries like SQLAlchemy and PyODBC for connecting to and interacting with various databases.
Python programming language
Agile/Scrum , Communication (Spoken English, clarity of thought)
Big Data, Data mining, machine learning and natural language processing
DevOps Engineer
Notice Period: 45 days / Immediate Joining
Banyan Data Services (BDS) is a US-based Infrastructure services Company, headquartered in San Jose, California, USA. It provides full-stack managed services to support business applications and data infrastructure. We do provide the data solutions and services on bare metal, On-prem, and all Cloud platforms. Our engagement service is built on the DevOps standard practice and SRE model.
We are looking for a DevOps Engineer to help us build functional systems that improve customer experience. we offer you an opportunity to join our rocket ship startup, run by a world-class executive team. We are looking for candidates that aspire to be a part of the cutting-edge solutions and services we offer, that address next-gen data evolution challenges. Candidates who are willing to use their experience in areas directly related to Infrastructure Services, Software as Service, and Cloud Services and create a niche in the market.
Key Qualifications
· 4+ years of experience as a DevOps Engineer with monitoring, troubleshooting, and diagnosing infrastructure systems.
· Experience in implementation of continuous integration and deployment pipelines using Jenkins, JIRA, JFrog, etc
· Strong experience in Linux/Unix administration.
· Experience with automation/configuration management using Puppet, Chef, Ansible, Terraform, or other similar tools.
· Expertise in multiple coding and scripting languages including Shell, Python, and Perl
· Hands-on experience Exposure to modern IT infrastructure (eg. Docker swarm/Mesos/Kubernetes/Openstack)
· Exposure to any of relation database technologies MySQL/Postgres/Oracle or any No-SQL database
· Worked on open-source tools for logging, monitoring, search engine, caching, etc.
· Professional Certificates in AWS or any other cloud is preferable
· Excellent problem solving and troubleshooting skills
· Must have good written and verbal communication skills
Key Responsibilities
Ambitious individuals who can work under their own direction towards agreed targets/goals.
Must be flexible to work on the office timings to accommodate the multi-national client timings.
Will be involved in solution designing from the conceptual stages through development cycle and deployments.
Involve development operations & support internal teams
Improve infrastructure uptime, performance, resilience, reliability through automation
Willing to learn new technologies and work on research-orientated projects
Proven interpersonal skills while contributing to team effort by accomplishing related results as needed.
Scope and deliver solutions with the ability to design solutions independently based on high-level architecture.
Independent thinking, ability to work in a fast-paced environment with creativity and brainstorming
http://www.banyandata.com" target="_blank">www.banyandata.com

