database engineer
- Optimized the knowledge modules to improve the functionality of the process.
- Fully involvement in every project, resolving issues arise while development and demo.
- Handling the issues and Interact with Client in Mail/ Status Call.
- Coordinated periodic fail over switch exercise to DR environment to test operational readiness of system
- Guided peers/team members
- Have experienced in any kind of issues related to lock escalation, application dependency and resources management across the server, high availability disaster recovery, Primary/Standby servers, 24/7 database up and running and escalation which may impact the business.
- Responsible for maintaining liaison with client DBA teams as and when required.
database engineer
- Worked on releases 8.x through 12.x of the application.
- Physical modeling of database changes and development of oracle pl/sql packages and Unix shell scripts to implement business functionality.
- Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and Router. These were
- developed as part of migration of overnight batch processing to Informatica.
- Lead database engineer for the Integrated Development Group which is responsible for Production Support and daily maintenance activities in staging and production.
- SQL/PLSQL tuning and optimization.
- Worked on data center migration effort.
database engineer
- Handle vast level of DB2 servers for more than 12 countries.
- Data analytical work during the peak sale time based on the customer purchasing using historical trend.
- Build recommendation system using ML and Python and SQL.
- Responsible for generating order calculation and order forecasting for a day.
- Churn Analysis of Tesco online stores based on customers 6 months activities.
- Shell scripting to automate database level backup, tables tuning, performance enhancement, error troubleshooting.
- Worked with application team, to prepare the SQL query based on their requirements.
database engineer
- Keeping a company’s database available, secure and stable
- Integrating new products and software packages into the system
- Sync Database between Test,sit,development,demo Server using Import and Export Utility.
- Shell Scripts, Cron Jobs for Automated Backup to NAS Drive.
database engineer
- Responsibilities include guiding peers/team members and mentoring as required.
- Part of Database professional services and Customer Success Engineering.
- Designing ,Creating schema according to predefined nomenclature and conventions.
- Expertise in Stored Procedures, Functions, Triggers using Oracle Tools like PL/SQL Developer,MYSQL Workbench.
database engineer
- Lead database engineer for the Integrated Development Group which is responsible for Production Support and daily maintenance activities in staging and production
- Responsible for the backend health of Production and Staging environments. Cut issue resolution time by 50% by building environment status dashboards, leading to timely insights on status of production data/environments
- Participated in DB capacity planning activities (Disk storage) with the Data Center Group
- Analyzed Database Storage trends and provided estimates to higher management for hardware procurement
- Coordinated overnight operations with offshore team in India
- Took lead in the implementation of database Auditing
- Participated in the planning, creation and setup of DR environments
database engineer
- Participated in the implementation of database Auditing.
- Participated in the planning, creation and setup of DR environments.
- Coordinate periodic fail over switch exercise to DR environment to test operational readiness of system.
- Responsible for tracking and reporting status of work assigned to the team to higher management.
database engineer
- Gained knowledge in how to operate database via Apache Servers.
- Documentation work on projects.
- Worked voluntarily in StoryCycle Project.
- Responsible for applying patches and fixes to the database with prior Approval from Change Control Board.
database engineer
- Wrote SQL queries to perform Data Analysis and Data Validation on the daily updated client’s data
- Designed a database for hospital management and presented a prototype version to the client
- Prepared database documentation and participated in unit testing and user acceptance testing for project deliverables
- Active Agile Scrum team member.
database engineer
- Installing and Configuring database on Linux and DB Creation.
- Maintaining Optimal Flexible Architecture.
- Managing Database Users, Security, Roles, Privileges and managing User Quotas
- Proactive Monitoring and Maintaining database performance via Java melody and percona monitoring.
- Managing backup and recovery strategies using mysqldump, percona xtra backup and Rman utilities.
- Maintaining a list of daily db activities followed for script monitoring and production deployment.
- Creating datamodel documents and various polices(stats,purging).
database engineer(dba)
- Administrating multiple database systems – Oracle/SQL Server/Sybase/SAP Hana/Db2/MySQL.
- Handling operations and solutions related to RDBMS technologies
- Troubleshooting and fixing issues related to Actifio and Database integration.
- Developing scripts(Oracle and Shell) based on project needs.
- In-depth understanding of Actifio and Copy Data Management products.
- Designing Backup and Recovery methodologies for different databases.
- Supporting application development and DevOps teams.
database engineer
- Worked on releases 8.x through 12.x of the application.
- Physical modeling of database changes and development of oracle pl/sql packages and Unix shell scripts to implement business functionality.
- Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, and Router. These were developed as part of migration of overnight batch processing to Informatica.
- Lead database engineer for the Integrated Development Group which is responsible for Production Support and daily maintenance activities in staging and production.
- SQL/PLSQL tuning and optimization.
- Worked on data center migration effort.
- Responsible for maintaining liaison with client DBA teams as and when required.
database engineer
- Create sql automation by using pandas and accelerate over 5 times speed.
- Responsible for GL and NM in Oracle.
- Write website by Asp.net and Bootstrap.
- Worked on Reference Data Integration Projects on Market Data Domain.
senior database engineer (dbe2)
- 11+ Years of Work Experience in SQL Server Development.
- Review, design, and develop data models, data mappings, and stored procedures with technical leaders and developers in support of product needs.
- Develop, test, and implement performance and resource optimization initiatives in consultation with development teams.
- Perform data research in support of data researchers, data analysts.
- Maintain a stable production environment with root cause analysis of production database issues as they arise
- Performance tuning the queries for optimal performance.
- Highly self-motivated and self-directed to solve complex technical problems in SQL Server.