11+ dbms Jobs in Hyderabad | dbms Job openings in Hyderabad

Job Description

Job Responsibilities

• Design and implement robust database solutions including

  • Security, backup and recovery

  • Performance, scalability, monitoring and tuning,

  • Data management and capacity planning,

  • Planning, and implementing failover between database instances.

• Create data architecture strategies for each subject area of the enterprise data model.

• Communicate plans, status and issues to higher management levels.

• Collaborate with the business, architects and other IT organizations to plan a data strategy, sharing important information related to database concerns and constrains

• Produce all project data architecture deliverables..

• Create and maintain a corporate repository of all data architecture artifacts.

Skills Required:

• Understanding of data analysis, business principles, and operations

• Software architecture and design Network design and implementation

• Data visualization, data migration and data modelling

• Relational database management systems

• DBMS software, including SQL Server  

• Database and cloud computing design, architectures and data lakes

• Information management and data processing on multiple platforms 

• Agile methodologies and enterprise resource planning implementation

• Demonstrate database technical functionality, such as performance tuning, backup and recovery, monitoring.

• Excellent skills with advanced features such as database encryption, replication, partitioning, etc.

• Strong problem solving, organizational and communication skill.

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

cid:[email protected]

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

07-13 years as an Oracle DBA with production support experience, including Oracle 10g and 11g.

07-13 years of experience as an Oracle Apps DBA with Oracle EBS 11.5.10 and R12

Strong understanding of Oracle RDBMS architecture

Hands-on experience with implementation, upgrade, and tuning of:

Large Oracle EBS environments, Oracle EBS in a production environment; throughout all stages of the lifecycle

Enterprise Manager Grid Control

Backup and recovery concepts, including RMAN

Oracle R12, Oracle RAC

Patch assessment and application in an EBS environment with activation of different modules

Performance Tuning (ie. Sql Queries)

Proven experience with multiple operating systems: Linux/Unix/Solaris/Windows

Strong verbal, written, organizational and documentation skills.

Ability to provide accurate and realistic effort estimates, commit and deliver accordingly

Ability to work in a fast paced environment with occasional non-business hours (evenings and weekends) flexibility and able to prioritize and juggle multiple projects.

Ability to work productively in a team environment and participate as a positive and cooperative team member.

MS in CS or BS/ BA in Computer Science with five years of relevant work experience.

Candidates should be flexible for Night shifts/Weekend Shifts

Preferred Skills:

Experience with Engineered Systems (ie. ODA's)

Oracle Data Guard

Oracle RAC/Multitenant architecture . WebLogic . OEM 13c/12c

R12.2 Upgrade Experience on multiple projects

Experienced with Oracle Identity Management product suite

Immediate Joiners preferred

CORE RESPONSIBILITIES

• Create and manage cloud resources in AWS 
• Data ingestion from different data sources which exposes data using different technologies, such as: RDBMS, REST HTTP API, flat files, Streams, and Time series data based on various proprietary systems. Implement data ingestion and processing with the help of Big Data technologies 
• Data processing/transformation using various technologies such as Spark and Cloud Services. You will need to understand your part of business logic and implement it using the language supported by the base data platform 
• Develop automated data quality check to make sure right data enters the platform and verifying the results of the calculations 
• Develop an infrastructure to collect, transform, combine and publish/distribute customer data.
• Define process improvement opportunities to optimize data collection, insights and displays.
• Ensure data and results are accessible, scalable, efficient, accurate, complete and flexible 
• Identify and interpret trends and patterns from complex data sets 
• Construct a framework utilizing data visualization tools and techniques to present consolidated analytical and actionable results to relevant stakeholders. 
• Key participant in regular Scrum ceremonies with the agile teams  
• Proficient at developing queries, writing reports and presenting findings 
• Mentor junior members and bring best industry practices 

QUALIFICATIONS

• 5-7+ years’ experience as data engineer in consumer finance or equivalent industry (consumer loans, collections, servicing, optional product, and insurance sales) 
• Strong background in math, statistics, computer science, data science or related discipline
• Advanced knowledge one of language: Java, Scala, Python, C# 
• Production experience with: HDFS, YARN, Hive, Spark, Kafka, Oozie / Airflow, Amazon Web Services (AWS), Docker / Kubernetes, Snowflake  
• Proficient with
• Data mining/programming tools (e.g. SAS, SQL, R, Python)
• Database technologies (e.g. PostgreSQL, Redshift, Snowflake. and Greenplum)
• Data visualization (e.g. Tableau, Looker, MicroStrategy)
• Comfortable learning about and deploying new technologies and tools. 
• Organizational skills and the ability to handle multiple projects and priorities simultaneously and meet established deadlines. 
• Good written and oral communication skills and ability to present results to non-technical audiences 
• Knowledge of business intelligence and analytical tools, technologies and techniques.

Mandatory Requirements 

• Experience in AWS Glue
• Experience in Apache Parquet 
• Proficient in AWS S3 and data lake 
• Knowledge of Snowflake
• Understanding of file-based ingestion best practices.
• Scripting language - Python & pyspark

• 2+ years experience working with Oracle Commerce Cloud application
• 4-6 years of overall experience in web application.

• Extensive knowledge of Oracle Commerce Cloud
• Excellent knowledge of server-side JAVA for enterprise level applications (J2EE)
• Experience in Javascript (Knockout preferred), Bootstrap, JQUERY, node.js, HTML 5, CSS
• Proficiency in SQL Server, MySQL, and relational data models in context of web integration
• Proficiency with web services (WCF, Web API, SOAP, REST, SOA)
• Excellent Communication Skills

•  Understanding of Oracle cloud technologies including technical
• Experience in working in an Agile environment

About Telstra

Telstra is Australia’s leading telecommunications and technology company, with operations in more than 20 countries, including In India where we’re building a new Innovation and Capability Centre (ICC) in Bangalore.

We’re growing, fast, and for you that means many exciting opportunities to develop your career at Telstra. Join us on this exciting journey, and together, we’ll reimagine the future.

Why Telstra?

• We're an iconic Australian company with a rich heritage that's been built over 100 years. Telstra is Australia's leading Telecommunications and Technology Company. We've been operating internationally for more than 70 years.
• International presence spanning over 20 countries.
• We are one of the 20 largest telecommunications providers globally
• At Telstra, the work is complex and stimulating, but with that comes a great sense of achievement. We are shaping the tomorrow's modes of communication with our innovation driven teams.

Telstra offers an opportunity to make a difference to lives of millions of people by providing the choice of flexibility in work and a rewarding career that you will be proud of!

About the team

Being part of Networks & IT means you'll be part of a team that focuses on extending our network superiority to enable the continued execution of our digital strategy.

With us, you'll be working with world-leading technology and change the way we do IT to ensure business needs drive priorities, accelerating our digitisation programme.

Focus of the role

Any new engineer who comes into data chapter would be mostly into developing reusable data processing and storage frameworks that can be used across data platform.

About you

To be successful in the role, you'll bring skills and experience in:-

Essential 

• Hands-on experience in Spark Core, Spark SQL, SQL/Hive/Impala, Git/SVN/Any other VCS and Data warehousing
• Skilled in the Hadoop Ecosystem(HDP/Cloudera/MapR/EMR etc)
• Azure data factory/Airflow/control-M/Luigi
• PL/SQL
• Exposure to NOSQL(Hbase/Cassandra/GraphDB(Neo4J)/MongoDB)
• File formats (Parquet/ORC/AVRO/Delta/Hudi etc.)
• Kafka/Kinesis/Eventhub

Highly Desirable

Experience and knowledgeable on the following:

• Spark Streaming
• Cloud exposure (Azure/AWS/GCP)
• Azure data offerings - ADF, ADLS2, Azure Databricks, Azure Synapse, Eventhubs, CosmosDB etc.
• Presto/Athena
• Azure DevOps
• Jenkins/ Bamboo/Any similar build tools
• Power BI
• Prior experience in building or working in team building reusable frameworks,
• Data modelling.
• Data Architecture and design principles. (Delta/Kappa/Lambda architecture)
• Exposure to CI/CD
• Code Quality - Static and Dynamic code scans
• Agile SDLC      

If you've got a passion to innovate, succeed as part of a great team, and looking for the next step in your career, we'd welcome you to apply!

___________________________

We’re committed to building a diverse and inclusive workforce in all its forms. We encourage applicants from diverse gender, cultural and linguistic backgrounds and applicants who may be living with a disability. We also offer flexibility in all our roles, to ensure everyone can participate.

To learn more about how we support our people, including accessibility adjustments we can provide you through the recruitment process, visit tel.st/thrive.

• 8+ years of experience in software development
• 4+ years of recent hands-on experience in architecting and building complex solutions that run in SaaS/PaaS environments, especially on AWS cloud leveraging SaaS based Microservices development coupled with Distributed Caching & Message Queuing.
• Should have experience in developing solution architecture and/or evaluate architectural alternatives for private, public and hybrid cloud models, including IaaS, PaaS, and other cloud services
• Should have excellent knowledge of cloud architecture and implementation features (OS, multi-tenancy, virtualization, orchestration, elastic scalability)
• Should have experience with Full Stack development with experience in technology stacks/frameworks like JAVA, Springboot, Python, Redis, SQL, NoSQL and Graph DBs
• Good to have Architected solutions that handle Big Data and should be proficient in data analytics
• Must have Expert level proficiency in Design / Architectural patterns, data structures and algorithms
• Must demonstrate knowledge of DevOps tool chains and processes
• Experience in web-based application migration from on-premise to SaaS model is a big plus.
• Experience of Integration patterns and associated best practice(e.g. Web Services, REST API's, Pub/Sub, MOM)
• Excellent knowledge and hands-on experience in Web services related, functionally decomposed architecture, Load Balancing of Web Services and applications, designing multi-tenant systems, Clustering and sharding of data, microservices architecture / design patterns, and throttling and performance management of such services