11+ Database architecture Jobs in Hyderabad | Database architecture 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.

About Company:

• Senior Engineer with a strong background and experience in cloud related technologies and architectures.
• Can design target cloud architectures to transform existing architectures together with the in-house team.
• Can actively hands-on configure and build cloud architectures and guide others.

• 3-5+ years of experience in AWS/GCP or Azure technologies
• Is likely certified on one or more of the major cloud platforms
• Strong experience from hands-on work with technologies such as Terraform, K8S, Docker and orchestration of containers.
• Ability to guide and lead internal agile teams on cloud technology
• Background from the financial services industry or similar critical operational experience
•  

Job location-Hyderabad, Bengaluru, Mumbai, Pune and Goa

CTC – As per market standard
Notice Period-Max 15 -30 days joiners

Responsibilities:

• Work with Database Architect to understand the design considerations for the BI Next Gen Data Warehouse.
• Take accountability of the development / update of the DW Database Objects and Code as per the requirement.
• Take accountability of the development / update of the PowerBI and SSRS Reports.
• Take accountability of Unit Testing the developed solution.
• Be available for weekend job monitoring and troubleshooting, as necessary.
• Ensure that all delivery timelines are adhered to.
• Work with QA (Testing) team to test the DW / Report Solution and fix as necessary.

Job Requirements:

• 8 - 10 years of experience in SQL Server database development.
• Excellent understanding of SQL Server 2016 and above.
• Excellent understanding of T-SQL. Must have the ability to analyze, debug and write complex T-SQL code.
• Very good hand-on knowledge on query tuning and performance optimization.
• Excellent understanding of SQL Server Integration Services and SQL Server Reporting Services.
• Excellent understanding of PowerBI.
• Should be completely aware of coding standards and should be able to develop high performance & scalable database applications.
• Exceptional Problem Solving and Analytical Skills.

Excellent communication skills (oral and written).

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

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

Required:
1) WebFOCUS BI Reporting
2) WebFOCUS Adminstration
3) Sybase or Oracle or SQL Server or Snowflake
4) DWH Skills

Nice to have:
1) Experience in SAP BO / Crystal report / SSRS / Power BI
2) Experience in Informix
3) Experience in ETL

Responsibilities:

• Technical knowledge regarding best practices of BI development / integration.
• Candidate must understand business processes, be a detailed-oriented person and quickly grasp new concepts.
• Additionally the candidate will have strong presentation, interpersonal, software development and work management skills.
• Strong Advanced SQL programming skills are required
• Proficient in MS Word, Excel, Access, and PowerPoint
• Experience working with one or more BI Reporting tools as Analyst/Developer.
• Knowledge of data mining techniques and procedures and knowing when their use is appropriate
• Ability to present complex information in an understandable and compelling manner.
• Experience converting reports from one reporting tool to another

8-16 years of overall database administration and support/operations experience, with a successful delivery track record.
# Proficient knowledge in  MySQL, HANA administration.
#Should have knowledge in setting up DR and HA approaches
#Should have strong Knowledge in Backup & Recovery.
# Should have played a L2 role in current position
# Experience of working in large landscape/environment where multiple database flavors are running.
# Knowledge on Database capacity planning/strategy is an added advantage
# Knowledge & Experience on other database as HANA flavors are added advantage
# Hands on experience with expert knowledge of Unix/Linux flavors w.r.t Database.
# Good understanding of operational framework like ITIL/ITSM.
# Should be capable of Owning, Leading and coordinate operational tasks, customer escalations, process improvements.
# Excellent presentation & communication skills are a must.