Role: Oracle DBA Developer
Location: Hyderabad
Required Experience: 8 + Years
Skills : DBA, Terraform, Ansible, Python, Shell Script, DevOps activities, Oracle DBA, SQL server, Cassandra, Oracle sql/plsql, MySQL/Oracle/MSSql/Mongo/Cassandra, Security measure configuration
Roles and Responsibilities:
1. 8+ years of hands-on DBA experience in one or many of the following: SQL Server, Oracle, Cassandra
2. DBA experience in a SRE environment will be an advantage.
3. Experience in Automation/building databases by providing self-service tools. analyze and implement solutions for database administration (e.g., backups, performance tuning, Troubleshooting, Capacity planning)
4. Analyze solutions and implement best practices for cloud database and their components.
5. Build and enhance tooling, automation, and CI/CD workflows (Jenkins etc.) that provide safe self-service capabilities to th6. Implement proactive monitoring and alerting to detect issues before they impact users. Use a metrics-driven approach to identify and root cause performance and scalability bottlenecks in the system.
7. Work on automation of database infrastructure and help engineering succeed by providing self-service tools.
8. Write database documentation, including data standards, procedures, and definitions for the data dictionary (metadata)
9. Monitor database performance, control access permissions and privileges, capacity planning, implement changes and apply new patches and versions when required.
10. Recommend query and schema changes to optimize the performance of database queries.
11. Have experience with cloud-based environments (OCI, AWS, Azure) as well as On-Premises.
12. Have experience with cloud database such as SQL server, Oracle, Cassandra
13. Have experience with infrastructure automation and configuration management (Jira, Confluence, Ansible, Gitlab, Terraform)
14. Have excellent written and verbal English communication skills.
15. Planning, managing, and scaling of data stores to ensure a business’ complex data requirements are met and it can easily access its data in a fast, reliable, and safe manner.
16. Ensures the quality of orchestration and integration of tools needed to support daily operations by patching together existing infrastructure with cloud solutions and additional data infrastructures.
17. Data Security and protecting the data through rigorous testing of backup and recovery processes and frequently auditing well-regulated security procedures.
18. use software and tooling to automate manual tasks and enable engineers to move fast without the concern of losing data during their experiments.
19. service level objectives (SLOs), risk analysis to determine which problems to address and which problems to automate.
20. Bachelor's Degree in a technical discipline required.
21. DBA Certifications required: Oracle, SQLServer, Cassandra (2 or more)
21. Cloud, DevOps certifications will be an advantage.
Must have Skills:
Ø Oracle DBA with development
Ø SQL
Ø Devops tools
Ø Cassandra
About Aprajita Consultancy
Similar jobs
Enterprise Minds, with core focus on engineering products, automation and intelligence, partners customers on the trajectory towards increasing outcomes, relevance, and growth.
Harnessing the power of Data and the forces that define AI, Machine Learning and Data Science, we believe in institutionalizing go-to-market models and not just explore possibilities.
We believe in a customer-centric ethic without and people-centric paradigm within. With a strong sense of community, ownership, and collaboration our people work in a spirit of co-creation, co-innovation and co-development to engineer next-generation software products with the help of accelerators.
Through Communities we connect and attract talent that shares skills and expertise. Through Innovation Labs and global design studios we deliver creative solutions.
We create vertical isolated pods which has narrow but deep focus. We also create horizontal pods to collaborate and deliver sustainable outcomes.
We follow Agile methodologies to fail fast and deliver scalable and modular solutions. We constantly self-asses and realign to work with each customer in the most impactful manner.
Pre-requisites for the Role
1.Job ID-EMSP0120PS
- Primary skill:
- Splunk Development and Administration
- Secondary skill:
Python, Splunk DB connect, Visual Studio (C#), BitBucket, Kafka, Devops tools.
- 4. Years of Experience: 5-8 Years
- Location:(Hybrid Model)-Pune
- Position-1
- Budget- - 5-6 years (Max up to 17 LPA) and 6-8 Years (Max up to 22 LPA)
- NP- Immediate
Primary Role & Responsibility:
As a software engineer, your daily work involves technically challenging applications and projects where your code makes a direct contribution to the further development and upkeep of our software suite and to its application in projects.
You should be able to create Splunk dashboards, apps and should have good understanding of source interfaces for Splunk.
You should have idea of onboarding of data from different sources like JSON, XML, syslog, errorlog files.
As a software engineer, we expect much more from you than just the ability to design and develop good software. We find it important that you possess an inherent drive to get the best out of yourself every day, that you are inquisitive and that you are not intimidated by situations which require you to branch off from the beaten track. You work together with colleagues in a SCRUM team. In addition, you have regular contact with other software teams, software architects, testers and end users. Good communication skills are therefore extremely important, as well as the ability to think pro-actively and suggest possible improvements. This gives you every opportunity to contribute your personal input and grow and develop within the department.
The often complex functionality of the software includes business logic, controls for logistical transport, communication with external computer systems, reporting, data analysis and simulation. This functionality is spread across various components. You design, program and test the software based on a design concept and a set of requirements. In some cases, you will have to personally formulate these requirements together with the (end) users and / or internal stakeholders. Learn more about the Software modular stack
Desired Profile & Experience: Knowledge of Kafka and experience with Java
- Splunk Architecture, on-premise and cloud based deployment.
- IoT edge.
- Analytical skills and capabilities to understand how raw (unstructured) data needs to be transformed into processed information.
Job Description:
- Configure and maintain database servers and processes
- Monitor the system's health and performance
- Ensure high levels of performance, availability, sustainability, and security
- Analyze, solve, and correct issues in real-time
- Provide suggestions for solutions
- Refine and automate regular processes, track issues, and document changes
- Assist developers with query tuning and schema refinement
- Provide on-call support for critical production systems
- Perform scheduled maintenance and support release deployment activities after hours
- Basic knowledge of SSRS, SSIS, and Postgres will be added advantage.
Job Description:
• Prepare the Test Summary Report and Test result report
• Analyzing the requirements and document test scenarios
• Version control of all configurable items
• Test case reviews
• Python scripting and test automation for embedded modules and test zigs (is a plus)
• Being a good team player
• Assisting team in technical issues
• Mentoring team
• Ensure customer satisfaction
• Communication - Seeking clarification, updating status
• Conduct Internal Audits
• Technical Interview Panel
• Good understanding of coding and testing standards
ob Description
We are looking for a Senior Perl Developer to join our team, who will help us working on solutions and implementing technologies that will improve user experience.
Responsibilities:
- Developing and maintaining large-scale Perl applications.
- Perform application modifications and enhancements based on business needs.
- Develop clean, high-quality and reusable codes based on programming standards.
- Coordinate with Project Manager to clearly understand business requirements and expectations.
- Stay abreast with latest trends in application development techniques and technologies.
- Suggest optimal application development solutions to meet or exceed business objectives.
- Develop best practices to ensure coding efficiency and quality.
- Analyze and resolve coding issues in a timely and accurate manner.
- Prepare and maintain coding documentations for reference purposes.
- Prioritize, plan and handle multiple tasks effectively.
- Ensure to complete the assigned development tasks within deadlines.
- Report project status to Manager on regular basis.
Qualifications
- 7+ years of experience in Perl development.
- Strong experience in Python.
- Experience of developing and maintaining shell scripts.
- Strong working knowledge in Perl and Unix based systems.
- Experience of developing database-driven web services/applications against SQL databases such as Oracle or MySQL.
- Good understanding of GIT and agile practices.
- BSc in IT related field.
- Detail focused, experience of reviewing technical documentation, diagrams and plans in order to help meet and/or define requirements.
- Able to communicate technical information verbally in a clear manner to both technical and non-technical stakeholders.
If Any one Intrested please DM Here
Along with updated Resume and Expected CTC and Notice period
What you will do:
- Customer Oriented: Being obsessed with providing the highest quality product and experience to the customer.
- A Go-Getter: Being a highly driven individual who goes that extra mile to deliver an outstanding product to the business team.
- Analytical and a Problem Solver: Understanding the needs and requirements and accordingly conceptualizing and designing solutions for the problems.
- Data Driven: Maintaining a track record of data driven decision making
- Adaptable: Demonstrating the ability to work in a fast paced and hyper-growth environment where the requirements are constantly changing.
- A Technology Geek: Being fanatical about technology and always on the look-out for newer and better ways of building solutions
- A Team Builder: Being a thoughtful interviewer/ mentor who constantly raises the bar for excellence. Mentoring and coaching tech talent to become tomorrow’s leaders, ensuring each new hire be significantly better than the team to raise the collective bar.
- A Visionary: Complementing product and design leadership with finding the right solution to the problems company is trying to solve for tomorrow.
- Entrepreneurial Mindset: Aligning our cross-functional teams to design and develop products aligned with our ambitions and strategy.
What you need to have:
- Good to have Bachelors/ Masters in Computer Science or a related field from IITs/ NITs/ BITS Pilani or other premium institutes
- 7 + years of overall experience with 2 to 5 years of people management experience as an Engineering / Software Development Manager
- Experience with managing people and projects is a must
- Expertise in J2EE server technologies
- Experience with web technologies and microservices architecture, Java, Linux, Apache, MySQL, solr, memcache, redis, javascript, ajax etc.
- Experience with high performance websites catering to high daily traffic is a plus
- Excellent teamwork skills, flexibility, and ability to handle multiple tasks
- Experience with API Design, ability to architect and implement an intuitive customer and third-party integration story
- Ability to think and analyze both breadth-wise (client, server, DB, control flow) and depth-wise (threads, sessions, space-time complexity) while designing and implementing services
- Exceptional design and architectural skills
- Some of the technologies/frameworks that we work on - Microservices Architecture, Python, Rest/gRPC, Node.js, MySQL, Postgres, AWS, ReactJS, React Native, Kubernetes
- Design, build web crawlers to scrape data and URLs.
- Integrate the data crawled and scraped into our databases
- Create more/better ways to crawl relevant information
- Strong knowledge of web technologies (HTML, CSS, Javascript, XPath, Regex)
- Understanding of data privacy policies (esp. GDPR) and personally identifiable information
- Develop automated and reusable routines for extracting information from various data sources
- Prepare requirement summary and re-confirm with Operation team
- Translate business requirements into specific solutions
- Ability to relay technical information to non-technical users
- Demonstrate Effective problem solving and analytical skill
- Ability to pay attention to detail, pro-active, critical thinking and accuracy is essential
- Ability to work to deadlines and give realistic estimates
Skills & Expertise
- 2+ years of web scraping experience
- Experience with two or more of the following web scraping frameworks and tools: Selenium, Scrapy, Import.io, Webhose.io, ScrapingHub, ParseHub, Phantombuster, Octoparse, Puppeter, etc.
- Basic knowledge of data engineering (database ingestion, ETL, etc.)
- Solution orientation and "can do" attitude - with a desire to tackle complex problems.
- Excellent knowledge with proven implementation experience of:
- Axiom Controller View V9 / V10 (2+ years’ experience).
- Building and configuring Axiom workflows to solve complex business problems and mapping to Axiom data dictionaries.
- XBRL and template disclosure submission including taxonomy, data point model and validations experience.
- Knowledge of EU regulatory reporting requirements (COREP/Statistical) with strong Capital knowledge.
- Packaging, deploying, branching Axiom solution including upgrades as part of the software development lifecycle.
- Oracle PL/SQL.
1. To strive for continuous improvement of both technical and business knowledge
2. Engage proactively with stakeholders and other cross-functional team members in the
development of IT solutions
3. Ensure new database code meets company standards for readability,reliability and performance
4. Passionate about technology and applying it to business solutions
5. Work closely with business
The Ideal Candidate:
1. 3-6 years development experience with SQL SERVER / MySQL platforms
2. Strong Knowledge of T-SQL
3. A good understanding of data normalization,data modelling and database schema design
principals
4. Knowlegde of database optimization techniques
5. Monitor database performance , implement changes and apply new patches and versions when
required
6. Automate regular process, track issues and document changes
7. Assist developers with complex query tuning and schema refinement
8. Proven working experience as a Database administrator
9. Experience with backups,restores and recovery models
10. Knowledge of High-Availability (HA) and Disaster Recovery(DR) options for SQL Server
11. Experience on AWS technologies (RDS,EC2,EBS,S3,RedShift,Glue)
12. Experience in implementation & support of NoSQL technologies
redis,memcached,mongodb,
13. Hands on programming experience in Python
14. Ability to multi-task and work independently
15. Proficient in Waterfall & Agile development methodology especially when applied to stae-full
data environments
Good to have :
1. Experience with Financial Data, Capital Markets and Mutual funds industry/data
1. Working experience on Data Warehouse projects or exhibits sound knowledge over the concepts
1. Understanding of Distributed Systems and Parallel Processing architecture