77 Database Architect jobs in Mumbai

• Managing Database access Security Checks Assessment create and maintain users' login and roles assign privileges Password Management etc
• Managing Database backups and restores including restores from Snapshots.
• Database Build Installation configuration OEM Service now tickets Idera New Relic Sumo
• Logic Emails
• Starting and stopping database services.
• Managing database related storage issues space management.
• Creation of Database Configuration Items in Service now and maintaining inventory
• Central Inventory Management
• CPU Utilization, Long running query, Apply latest patches to database servers
• Ensure best practice security standards are applied to database servers
• Database Refresh restores and cloning from Prod to nonprod
• Database performance tuning
• Follow best practice methods to commission and decommission database server
• Ensure database changes are applied with best practices and tested in lower environments
• prior to prod deployment, Script execution deployment
• Basic HADRRAC Cluster Data guard Replication Administration
• Manage RDS Instances across different environments including rightsizing
• Monitoring Tool User Setup
• Leverage Terraform State management capabilities to track changes and maintain the
• desired state for RDS sources
• Monitor Terraform execution logs and plan outputs to troubleshoot provisioning issues and
• ensure RDS instances are provisioned as expected
• Snowflake Troubleshooting Table locking issue
• Snowflake SSL certificate deployment
• PostgreSQL Kerberos user Management, PostgreSQL Database Vacuum
• MySQL Objects partition LOB, Materialized view log maintenance
• MongoDB SSRS Key storage locations, MongoDB Transparent Data Encryption TDE
• MongoDB Row Level Encryption, MongoDB Logs compression
• MSSQL SSIS Package deployment Migration
• MSSQL SSRS Migration Update data source Migrate deploy reports etc
• MSSQL IP Whitelisting on MSSQL RDS instances
• Oracle OEM configuration Maintenance and enable Monitoring
• Oracle OMS version Migration and Upgradation
• Oracle Data guard Setup and DGMGRL configuration
• Oracle Installing Oracle server and client software
• Oracle Terraform Version and AWS version updates on all git hub repository
• Oracle Refresh RDS instance Point Intime using Snapshots
• Oracle RAC Build activities Grid Oracle Installation and cluster database creation
• Oracle Option Group Management on AWS Cloud
• Oracle Time zone Upgrade activities via OG in Terraform

Mandatory Skills: Mongo DBA, MySQL DBA, Redis DBA, Sybase DBA, Azure Database Service, AWS Database Service, GoldenGate-DB Administration, PostgreSQL-DB Administration, Cassandra DBA, Oracle DB Administration, MS SQL DB Administration, GCP Database Services, Couch DBA, DB2-LUW DB Administration, MariaDB, Maria DBA

Job Title: MS SQL Database Architect

Experience: 6 years

Location: Remote

Job Type: Full-Time

Project required to work upon:

1. Split the one big SQL DB into multiple smaller DB and maintaining the entity sanctity
2. SQL Scripting and versioning process to the release
3. Migrate East DB data to west DB and eliminate east DB
4. Once DB is split migrate data to MongoDB (This would also require Dev team involvement)

Required Skills:

• Strong experience with MS SQL Server - T-SQL
• Experience with data modelling, database design principles
• Ability to write and execute complex SQL scripts for data manipulation, querying, and
• reporting.
• Knowledge of CI/CD pipelines for databases using tools like Git or equivalent.
• Analyse database landscapes to identify migration challenges, risks, and opportunities, translating these into technical specifications and migration plans.
• Collaborate closely with cross-functional teams to ensure alignment of proposed migration solutions with technical capabilities and product roadmaps.
• Prepare comprehensive technical documentation, migration plans, and proposals, articulating migration strategies, methodologies, and expected outcomes clearly.
• Stay abreast of the latest trends, tools, and best practices in database migration, ensuring the proposed solutions incorporate cutting-edge methodologies and
• technologies.
• Planning and executing data migration projects, including moving data from existing systems to DB like Mongo DB.

Soft Skills:

• Strong analytical and problem-solving abilities.
• Effective communication and documentation skills.
• Ability to speak to various stakeholders/Team like Dev Team, DBA, Solution architects,
• business analyst etc.
• Leadership and mentorship qualities.

Standort

Indien

Maharashtra

Pune

Unternehmen

Siemens Energy Industrial Turbomachinery India Private Limited

Organisation

Transformation of Industry

Geschäftsbereich

Compression

Vollzeit / Teilzeit

Vollzeit

Erfahrungsniveau

Berufserfahrene

A Snapshot of Your Day

• You will be responsible to demonstrate a personal commitment to perfection, actively support and participate in the Total Quality process, promote positive change, and encourage continuous process improvement. Contribute to teamwork by building alliances among work units and cooperating effectively with others to achieve departmental and operational objectives.
• Support the company's Equal Employment Opportunity Policy, including the implementation of affirmative action plans. Operate in a manner that ensures compliance with all federal, state, and local employment legislation

How You'll Make an Impact

• Coordinate with the Cost Out Manager to obtain the input and data sheets required to create tasks in the SE-specific Cost Out tool.
• Create the product baseline structure, update attributes, and publish the tasks. Regularly follow up on measures with the task owner and ensure progress is updated in the Cost Out tool.
• Demonstrate adequate knowledge and experience in using JIRA for project management and issue tracking.
• Manage the creation of Monthly, Weekly, and Daily Reports in MS Excel using sophisticated features (including Pivot Tables and VLOOKUP), VBA (Macros), and Power BI at the operational level.
• Organize and maintain the tracking system and files for easy retrieval of information when needed.
• Have experience with supply chain management (SCM) activities, including quotations, purchase orders (PO), and goods receipt notes (GRN) processes.
• Apply A3 problem-solving techniques to identify root causes and develop effective solutions.

What You Bring

• Bachelor's degree in mechanical or production engineering with 5+ Years of Working experience in compressor and gas turbine equipment
• Experience in Data Presentation: Proficient in presenting data in graphical formats.
• Advanced Excel Certification: Certification in Advanced Excel Training is a plus.
• Strong English Language Skills: Excellent communication skills in English, both written and verbal.
• Ability to effectively interact with a high volume of Siemens project personnel in day-to-day responsibilities.
• Capable of managing time effectively and prioritizing workloads to meet deadlines

About the Team

Our Transformation of Industry division is decarbonizing the industrial sector. Increasing electrification and efficiency are key and demand for green H2 and derivative fuels will rise. We enable decarbonization of the industrial sector and the transition to sustainable processes, building on a strong industrial customer base, a global network, diverse technologies, and integrated execution capabilities. Candidates want to learn about the divisions they will be joining–the structure, how it works together, and the role it plays in driving Siemens Energy's mission forward.

Who is Siemens Energy?

At Siemens Energy, we are more than just an energy technology company. With ~100,000 dedicated employees in more than 90 countries, we develop the energy systems of the future, ensuring that the growing energy demand of the global community is met reliably and sustainably. The technologies created in our research departments and factories drive the energy transition and provide the base for one sixth of the world's electricity generation.

Our global team is committed to making sustainable, reliable, and affordable energy a reality by pushing the boundaries of what is possible. We uphold a 150-year legacy of innovation that encourages our search for people who will support our focus on decarbonization, new technologies, and energy transformation.

Find out how you can make a difference at Siemens Energy:

Our Commitment to Diversity

Lucky for us, we are not all the same. Through diversity, we generate power. We run on inclusion and our combined creative energy is fueled by over 130 nationalities. Siemens Energy celebrates character – no matter what ethnic background, gender, age, religion, identity, or disability. We energize society, all of society, and we do not discriminate based on our differences.

Rewards/Benefits

• All employees are automatically covered under the Medical Insurance. Company paid considerable Family floater cover covering employee, spouse and 2 dependent children up to 25 years of age.
• Siemens Energy provides an option to opt for Meal Card to all its employees which will be as per the terms and conditions prescribed in the company policy as a part of CTC, tax saving measure
• Flexi Pay empowers employees with the choice to customize the amount in some of the salary components within a defined range thereby optimizing the tax benefits. Accordingly, each employee is empowered to decide on the best Possible net income out of the same fixed individual base pay on a monthly basis

eClerx is hiring – Apprentice Analyst (Product Data Management) | Mumbai Location

We are looking for
B.E. Mechanical freshers
to join our
Product Data Management team
in Mumbai.

Role Overview:

As an Apprentice Analyst, you will work on enhancing online product data quality for Electrical, Mechanical & Electronics products. Your role will include creating technical specifications, product descriptions, and supporting consultancy projects related to e-commerce taxonomy and navigation.

Key Responsibilities:

• Data enrichment, standardization, normalization, and categorization of product data using research from multiple sources (internet, databases, etc.)
• Conducting data quality checks and corrections
• Basic data profiling and reporting
• Communicating with clients via email for request acknowledgment, project updates, and query responses
• Enhancing product data quality (technical specifications & descriptions) for categories like pumps, motors, HVAC, plumbing, etc.
• Supporting category managers with industry best practices for product data enhancement

Skills & Qualifications:

• Education:
  B.E. in Mechanical Engineering (Mandatory)
• Strong technical knowledge of mechanical/engineering products (pumps, motors, HVAC, plumbing, etc.)
• Basic to intermediate knowledge of MS Office & internet research
• Good communication and collaboration skills

Location:
Mumbai

Eligibility:
Freshers (B.E. Mechanical only)

Compensation:
₹18,000 (in-hand) per month

Interested candidates can share their resumes at L

ROLES & RESPONSIBILITIES

1 ETL (Informatica & IICS)

2 PL/SQL

3 Python (Nice to have)

4 Unix Experience (Helpful)

• In-depth knowledge of Software Development Life Cycle (SDLC), having a thorough understanding of various phases such as Requirement gathering, Analysis, Design, Development, and Testing.
• Extensive ETL experience using Informatica PowerCenter (Designer, Workflow Manager, Workflow Monitor).
• Excellent in designing ETL procedures and strategies to extract data from different heterogeneous source systems like Oracle, SQL Server, MongoDB, PostgreSQL, DB2, Flat files, JSON, XML.

• Expertise in Developing Mappings and Mapplets/Transformations between Source and Target using Informatica Designer.

• Created mappings in mapping Designer to load data from various sources using transformations like Transaction Control, Lookup (Connected and Un-connected), Router, Filter, Expression, Aggregator, Joiner and Update Strategy, SQL, Stored Procedure and more.

• Experience in handling initial/full and incremental loads.

• Expertise in scheduling workflows Windows scheduler, Unix, and scheduling tools like Apache airflow

• Good knowledge of database language PL/SQL and writing complex SQL Queries to validate source and target data

• Experience in creating Tables, Views, Stored Procedures, and Indexes, troubleshooting database issues and Performance Tuning of Stored Procedures and Database queries.

• Involved in the logical and physical data modeling process to develop corresponding DB objects & ETL flows.

• Knowledge of handling inbound/outbound secured SFTP file transfer.

• Hands-on experience working in LINUX or UNIX Shell scripting

• Knowledge of Python

EXPERIENCE

6-8 Years

SKILLS

Primary Skill: Data Management

Sub Skill(s): Data Management

Additional Skill(s): Python, ETL, DataOps Engineering, Data Preparation, Insight Generation

ABOUT THE COMPANY

Infogain is a human-centered digital platform and software engineering company based out of Silicon Valley. We engineer business outcomes for Fortune 500 companies and digital natives in the technology, healthcare, insurance, travel, telecom, and retail & CPG industries using technologies such as cloud, microservices, automation, IoT, and artificial intelligence. We accelerate experience-led transformation in the delivery of digital platforms. Infogain is also a Microsoft (NASDAQ: MSFT) Gold Partner and Azure Expert Managed Services Provider (MSP).

Infogain, an Apax Funds portfolio company, has offices in California, Washington, Texas, the UK, the UAE, and Singapore, with delivery centers in Seattle, Houston, Austin, Kraków, Noida, Gurgaon, Mumbai, Pune, and Bengaluru.

Job Responsibilities -

• 2-9+ years - work experience within Employee Data Management operations Demonstrate ability and integrity when working with confidential data.
• Excellent communication (verbal and written), organizational, and coordination skills
• Strong service orientation with demonstrated desire and willingness to serve the team and its customers
• Ability to take initiative; be proactive without waiting for direction; strong sense of personal accountability MS Office & Excel Skills.
• Proven leadership experience managing large HR operations teams.
• Expertise in HR systems (SAP SuccessFactors, HRIS platforms) and data governance.
• Strong project management and transformation/automation experience
• Excellent analytical, problem-solving, and decision-making skills
• Ability to influence senior stakeholders and drive organizational change.
• Employee Data Management/HCM/HR Administration/HR Operations
• Lead the Employee Data Management team, ensuring efficient delivery of HR operations across multiple processes.
• Define team objectives, KPIs, and SLAs aligned with organizational goals.
• Oversee escalations, complex cases, and cross-functional HR data initiatives.
• Partner with HR leadership, business leaders, and IT to streamline processes and enhance HR systems.
• Drive continuous improvement, automation, and transformation initiatives.
• Ensure compliance with data privacy, labor laws, and audit requirements.
• Manage workforce planning, resource allocation, and team performance management. Provide strategic input on HR operations and contribute to organizational HR projects.

Contact Person - Marilakshmi S

Email -