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.

Snowflake SRE JD

Your Role Accountabilities

• Primarily responsible for administrating Snowflake environments on AWS
• Identify, tune, and fix the performance issues on priority.
• Diagnose and troubleshoot Snowflake related errors and work with team to raise support tickets, follow ups and help to resolve them.
• Implement security, roles, users and privileges using the best practices.
• Provide database/objects recovery as need on basis.
• Design, identify and implement high performing and highly available data warehouse solutions.
• Create database, schema, tables, views, data sharing
• Create Snowflake utilization and capacity/cost plans, identifies, and provide solution for abnormalities.
• Proactively identify, design, and implement process improvements like automating manual processes
• Stay up-to-date with the latest features and best practices in Snowflake administration
• Follow existing database runbooks, create and maintain new runbooks for new and improved processes
• Provide 24X7 On-call support by participating in rotation schedule.

Qualifications & Experiences

• Bachelor's degree in computer science, information systems, or information technology.
• 10+ years of experience as a database administrator.
• Minimum 5+ years of hands-on administration experience, from setting up the Snowflake environments to successfully administering it (AWS preferred)
• Experience automating, scripting, and streamlining processes for efficiency and accuracy utilizing Unix shell scripting, Python etc.
• Some experience with AWS with knowledge of S3, EC2, VPC, IAM, Security, Networking etc.
• Ability and experience with the development of processes and procedures to standardize Database configuration
• Extensive experience with implementation and maintenance of Disaster Recovery and High availability.
• Ability to work on unusually complex technical problems and provide solutions that are highly innovative and ingenious.
• Ability to provide technical documentation and project plans for technical staff members.
• Excellent communication, presentation, and customer relationship skills.
• Excellent organizational and time management skills to handle multiple tasks simultaneously
• Ability to provide 24/7 support.

Designation: Senior - DBA

Experience: 6-9 years

CTC: INR 17-20 LPA

Night Allowance: INR 800/Night

Location: Hyderabad,Hybrid

Notice Period: NA

Shift Timing : 6:30 pm to 3:30 am

Openings: 3

Roles and Responsibilities:

As a Senior Database Administrator is responsible for the physical design development

administration and optimization of properly engineered database systems to meet agreed

business and technical requirements.

The candidate will work as part of but not limited to the Onsite/Offsite DBA

group-Administration and management of databases in Dev Stage and Production

environments

Performance tuning of database schema stored procedures etc.

Providing technical input on the setup configuration of database servers and SAN disk

subsystem on all database servers.

Troubleshooting and handling all database related issues and tracking them through to

resolution.

Pro-active monitoring of databases both from a performance and capacity management

perspective.

Performing database maintenance activities such as backup/recovery rebuilding and

reorganizing indexes.

Ensuring that all database releases are properly assessed and measured from a

functionality and performance perspective.

Ensuring that all databases are up to date with the latest service packs patches &

security fixes.

Take ownership and ensure high quality timely delivery of projects on hand.

Collaborate with application/database developers quality assurance and

operations/support staff

Will help manage large high transaction rate SQL Server production

Eligibility:

Bachelors/Master Degree (BE/BTech/MCA/MTect/MS)

6 - 8 years of solid experience in SQL Server 2016/2019 Database administration and

maintenance on Azure and AWS cloud.

Experience handling and managing large SQL Server databases in a real time production

environment with sizes greater than 200+ GB

Experience in troubleshooting and resolving database integrity issues performance

issues blocking/deadlocking issues connectivity issues data replication issues etc.

Experience on Configuration Trouble shoot on SQL Server HA

Ability to detect and troubleshoot database related CPUmemoryI/Odisk space and other

resource contention issues.

Experience with database maintenance activities such as backup/recovery & capacity

monitoring/management and Azure Backup Services.

Experience with HA/Failover technologies such as Clustering SAN Replication Log

shipping & mirroring.

Experience collaborating with development teams on physical database design activities

and performance tuning.

Experience in managing and making software deployments/changes in real time

production environments.

Ability to work on multiple projects at one time with minimal supervision and ensure high

quality timely delivery.

Knowledge on tools like SQL Lite speed SQL Diagnostic Manager App Dynamics.

Strong understanding of Data Warehousing concepts and SQL server Architecture

Certified DBA Proficient in TSQL Proficient in the various Storage technologies such as

ASM SAN NAS RAID Multi patching

Strong analytical and problem solving skills Proactive independent and proven ability to

work under tight target and pressure

Experience working in a highly regulated environment such as a financial services

institutions

Expertise in SSIS SSRS

Skills:

SSIS

SSRS

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

Job Title: Data Engineer

Job Summary: As a Data Engineer, you will be responsible for designing, building, and maintaining the infrastructure and tools necessary for data collection, storage, processing, and analysis. You will work closely with data scientists and analysts to ensure that data is available, accessible, and in a format that can be easily consumed for business insights.

Responsibilities:

• Design, build, and maintain data pipelines to collect, store, and process data from various sources.
• Create and manage data warehousing and data lake solutions.
• Develop and maintain data processing and data integration tools.
• Collaborate with data scientists and analysts to design and implement data models and algorithms for data analysis.
• Optimize and scale existing data infrastructure to ensure it meets the needs of the business.
• Ensure data quality and integrity across all data sources.
• Develop and implement best practices for data governance, security, and privacy.
• Monitor data pipeline performance / Errors and troubleshoot issues as needed.
• Stay up-to-date with emerging data technologies and best practices.

Requirements:

Bachelor's degree in Computer Science, Information Systems, or a related field.

Experience with ETL tools like Matillion,SSIS,Informatica

Experience with SQL and relational databases such as SQL server, MySQL, PostgreSQL, or Oracle.

Experience in writing complex SQL queries

Strong programming skills in languages such as Python, Java, or Scala.

Experience with data modeling, data warehousing, and data integration.

Strong problem-solving skills and ability to work independently.

Excellent communication and collaboration skills.

Familiarity with big data technologies such as Hadoop, Spark, or Kafka.

Familiarity with data warehouse/Data lake technologies like Snowflake or Databricks

Familiarity with cloud computing platforms such as AWS, Azure, or GCP.

Familiarity with Reporting tools

Teamwork/ growth contribution

• Helping the team in taking the Interviews and identifying right candidates
• Adhering to timelines
• Intime status communication and upfront communication of any risks
• Tech, train, share knowledge with peers.
• Good Communication skills
• Proven abilities to take initiative and be innovative
• Analytical mind with a problem-solving aptitude

Good to have :

Master's degree in Computer Science, Information Systems, or a related field.

Experience with NoSQL databases such as MongoDB or Cassandra.

Familiarity with data visualization and business intelligence tools such as Tableau or Power BI.

Knowledge of machine learning and statistical modeling techniques.

If you are passionate about data and want to work with a dynamic team of data scientists and analysts, we encourage you to apply for this position.

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.

Job Description:

Candidate should ideally be a B.E/B.Tech graduate with around 3 to 5 years of experience, with core T-SQL scripting , performance tuning, SSIS, NOSQL skills. The current role requires a core T-SQL , NoSQL and SSIS developer. The SQL Developer will be responsible for:

• Creating & designing database and all database objects such as tables, views, StoredProcedures, functions etc.
• Writing and troubleshooting simple to complex SQL scripts, stored procedures, views, functions, etc. as per the requirement.
• Troubleshooting and fixing all performance issues with respect to databases (objects & scripts).
• SQL Query tuning and performance tuning.
• Develop/migrate existing scripts to SSIS.
• Maintaining referential integrity, domain integrity and column integrity by using the available options such as constraints, etc.
• Maintaining database objects (like tables, views,Stored Procedures) performance by following the tuning tips like normalization, indexes, etc.
• Importing and exporting the data from different sources using tools, writing required scripts.
• Works closely with other members of the team to accomplish the projects.
• Assists project teams to design and develop core business components utilizing  industry-accepted analysis and design standards.
• Provides and/or assists with, project management and project leadership.
• Create and maintain documentation for all the projects.
• Working with NOSQL databases (Mostly on MongoDB) .

PRIMARY SKILLS: 

TSQL, SQL, NoSQL, Performance Tuning, SSIS, Import & Export of data from different data sources and from different formats.

SECONDARY SKILLS:

Database Administration

REQUIRED SKILLS:

• 3+ years of professional experience in working with MSSQL Server 2008 and above.
• 3+ years of professional experience in writing TSQL scripts.
• Thorough experience in SQL query tuning and performance tuning.
• Experience in developing and maintaining SSIS packages.
• Experience in working with NoSQL databases. MongoDB would be preferable.
• Fluent knowledge of MSSQL server DBA.
• Should be a good team player and should possess good attitude and work ethics.
• Should possess excellent communication and written skills.

PREFERRED SKILLS:

• MSSQL DBA.
• SSIS.
• NOSQL, MongoDB

• 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

• 4-7 years of Industry experience in IT or consulting organizations
• 3+ years of experience defining and delivering Informatica Cloud Data Integration & Application Integration enterprise applications in lead developer role
• Must have working knowledge on integrating with Salesforce, Oracle DB, JIRA Cloud  
• Must have working scripting knowledge (windows or Nodejs) 

Soft Skills 

• Superb interpersonal skills, both written and verbal, in order to effectively develop materials that are appropriate for variety of audience in business & technical teams
• Strong presentation skills, successfully present and defend point of view to Business & IT audiences
• Excellent analysis skills and ability to rapidly learn and take advantage of new concepts, business models, and technologies