Manpreet

Database Architect
placeholder
Location Noida
view-icon
Total Views32
availability
Shortlist0
back in time
Member since30+ Days ago
 back in time
Contact Details
phone call {{contact.cdata.phone}}
phone call {{contact.cdata.email}}
Candidate Information
  • User Experience
    Experience 17 Year
  • Cost
    Hourly Rate$40
  • availability
    AvailabilityImmediate
  • work from
    Work FromOffsite
  • check list
    CategoryArchitecture & Planning
  • back in time
    Last Active OnMarch 30, 2023
Key Skills
database architect oracle rac aws redshift mysql postgresql oracle standby database aws rds
Summary

 

EXPERIENCE

 


Period             : Nov 2021 – Till Present 


Client             : NCR- D3 Banking       

Role                : Sr.Database Architect 

 

 

Summary (Project): D3 Banking, Supporting AWS RDS database MYSQL. AWS DMS replication. Designing and supporting architectural decisions , documentation, Go-Live planning Run-book and support

 

Responsibilities:

 

·        Supporting on architectural decisions

·        Managing team to handle AWS MYSQL RDS and suggesting the right approach for better performance and design

·        NO SQL Database Astra DB (Cassandra), design and deployment support

·        AWS DMS Replication design and support, troubleshooting AWS DMS

·        Go-Live planning and supporting team with required

·        Tracking , assigning and working on JIRA

 




Period             : Sep 2019 – Nov 2021    


Client              : Product based company                   

Role                : Database Architect     

 

Summary (Project): Cloud application having AWS RDS database like MYSQL and PostgreSQL. One of the pioneers in selling franchise management software in the market majorly in united states, partially in Canada, Australia, and Europe.

 

Responsibilities:

 

·        Designing solution for AWS cloud Aurora RDS (MYSQL/PostgreSQL), MongoDB Atlas, AWS Redshift cluster

·        Dimension modelling for KPI management (Star flake schema, Redshift)

·        Planning with scrum team to achieve sprint goals.

  • Architectural decisions and planning for better and scalable designs.
  • Designing and helping in migration of Premises database to AWS
  • Handling team of DBAs to support Scrum team.
  • Solutioning AWS issues with CloudWatch, advance monitoring solutions
  • Working closely with DevOps team to design automate DB refresh and restoration processes.
  • Designed Read/Write separation for AWS RDS
  • Planning with the team and design the process for RDS upgrade for security and performances

 

Environment: AWS RDS, AWS EC2, MongoDB, Redshift, AWS Glue.

 

 


Period             : Oct 2007 – Sep 2019                         


Client              : USCC (US), AIS (Thailand), Ooredoo (Qatar), VHA (Australia), Powell’s (US)      

Role                : Database Administrator/Technical Manager DBA                                  

Summary        : Clients having mixed cloud and bare metal environment in telecom domain, bookstore, Banking etc.

Responsibilities:

·         Leading the team and providing solution to work on automation of the Application installation etc.
·         Installed Oracle Database 11g/10g with Real Application Cluster (RAC) , MSSQL , MYSQL, HADOOP , MONGO DB , COUCHBASE DB, POSTGRESQL DB on Windows and Linux.
·         Managing Oracle RDBMS, HADOOP, SQL server, MYSQL and NOSQL databases
·         RAC administration using SRVCTL.
·         HADOOP big data having 150 data nodes for multiple clients.
·         Configuring ASM Libraries and creating volumes
·         Handling Production and Development Databases for different Projects which includes MSSQL, Oracle 8i,9i,10G,11G of 7 (Collectively)
·         ASM Disk Group Expansion

.

Environment: AWS RDS, Hadoop, Oracle, Hive, Couchbase, MSSQL, Oracle RAC, Oracle DG

 


Period             : Jan 2007 – Oct 2007


Client              : BSNL                       

Role                : Database Administrator                                  

Summary        : Supporting for Databases in BSNL Ghaziabad. Was responsible for database to be up and running 24*7 with smooth transactions. Perform backups to recover database incase of any hardware failure

Responsibilities:

  • To create and maintain Table spaces, Tables, Indexes, Views, Constraints, Synonyms, Users Account, Roles and Privileges, Space Allocation
  • Controlling and monitoring of users account to the database including Grant and Revoking of Privileges and roles and Table space quotas
  • Trouble shooting for backup, recovery, and any other database issues.
  • Back and Recovery both users managed and rman managed.
  • Planning and implementing physical backup and recovery strategy for the production database including logical backup like export and import


Copyright : 2022 – OnBenchMark All Right Reserved.
Submit Query