Aakash Deep Singh
Site Reliability Database Engineer| Lead DBA | DevOps (CI/CD) | Data Analyst at Tata Consultancy Services
Assistant Consultant | Site Reliability Database Engineer | Lead DBA | DevOps (CI/CD) | Data Analyst at Tata Consultancy Services
Cross-functional IT professional responsible for Database Administration, Site Reliability, Dev Ops, Deployment, Data Analysis. 10+ years experience & excellent reputation for managing & migrating databases, upgrading legacy systems, architecture designs, , automation for various mission critical projects across USA & INDIA.
Tata Consultancy Services
https://www.linkedin.com/company/tata-consultancy-services
•Installing database servers and creating databases on different environments.
•High level design of database table spaces, buffer pools and schema creation.
•Physical and logical data modeling of data objects, data reconciliation and profiling.
•Migrating data from legacy non-relational systems to relational databases.
•Ensuring business continuity by performing & implementing data maintenance, backup planning and recovery, data reorganization and updating database statistics.
•Integrating transactional databases to data warehouse and operational data store.
• Managing releases and deploying code in different environments.
•Identifying manual steps in deployment and automate to minimize risks.
•Application & database server monitoring and performance optimization, SQL analysis, database tuning and managing configurations.
•Reduced expensive CPU cost of legacy systems by creating compute nodes for availability data using Kafka.
•Ability to work with large data sets and to translate data into meaningful value.
•Provide expert level technical guidance, documentation and directions to peers, peer groups, and client.
•Performing feasibility study, requirement analysis and impact analysis for code releases of new/existing changes or enhancements.
•Data Security implementation with SSL, data encryption and data masking.
•Expert in automating & monitoring server related activities using shell scripting.
•Expert in developing, automating, deploying ETL data pipelines.
•Extensive capacity planning, monitoring and space management.
•Ensuring business continuity by performing & implementing data maintenance, backup planning and recovery, data reorganization and updating database statistics.
•Database release management/Data retention management/Database object remarks management/ IBM CDC access server management for replication.
•IBM bidirectional Q-Replication implementation, configuration and support.
Jefferson City, Missouri
https://media-exp1.licdn.com/dms/image/C4E0BAQEMvQ8E6gXSPA/company-logo_100_100/0/1625820626997?e=1655942400&v=beta&t=Cf59imZByMhBQGGc3pndkq2CClsqo3bZFeHd3fGQZSQ
Site Reliability Database Engineer| Lead DBA | DevOps (CI/CD) | Data Analyst
Tata Consultancy Services
https://www.linkedin.com/company/tata-consultancy-services
• Physical and logical data modelling of database objects.
• Ensured business continuity by performing data maintenance, backup planning and recovery, data reorganization and updating database statistics.
• SQL Analysis and optimization, analyzing and tuning database manager and database configurations.
• Implementing and managing database row and column access control.
• Providing support for migration of data from legacy system using SAP BODS tool.
• Created Data mapping specification documents which has transformation logic from Source to Target tables.
• Data movement across multiple environments. Loaded and refreshed non-production databases for application testing.
• Identifying business requirement and suggesting structural changes in database.
• Assisted developers in database and application tuning for optimal performance.
• Prepared detailed improvement plans of problem records and their resolutions.
• Supported applications in production by handling and determining the root cause analysis for issues as they come up and conducted crisis control while addressing these issues as a key element for keeping customer satisfaction.
• Implemented and managed ORACLE Golden Gate and IBM CDC for Replication and data migration.
• Reduce manual efforts and inefficiencies by creating MQT and CRON scheduled database jobs.
• Increase federal and state compliance by implementing SSL and FTI policies.
• Implemented Roles and Group level database permissions. Applies masking in database to restrict data access.
Jefferson City, Missouri
https://media-exp1.licdn.com/dms/image/C4E0BAQEMvQ8E6gXSPA/company-logo_100_100/0/1625820626997?e=1655942400&v=beta&t=Cf59imZByMhBQGGc3pndkq2CClsqo3bZFeHd3fGQZSQ
ITA | Lead Database Administrator
Tata Consultancy Services
https://www.linkedin.com/company/tata-consultancy-services
• DB2 Database Administrator for 30+ servers where DB2 Database is installed on AIX environment. 
• Maintained more than 30 instances and 50 databases in partitioned and non partitioned environment in TEST, DEV and PRODUCTION.
• Handled heavy DB where production databases size was up to 4 TB.
• Resolved Problem tickets of different severity levels during production support.
• Monitored tablespace growth using standard scripts and working with trend analysis data.
• Handled tablespace and filesystem space issues.
• Executing DDL and DML scripts as per customer request.
• Granting / revoking various authorizations to different Users/Groups.
• Creating and updating scripts for database related automation jobs.
• Working with data movement Utilities i.e. import, export and load.
• Working with Data warehousing team to monitor LOAD operations and SQL performance tuning.
• Monitoring scheduled jobs like backup, reorg, runstats etc.
• Troubleshooting DB2 problems using different tools and utilities.
• Regularly monitoring Prod/Test environment and making necessary changes to keep Prod and Test environment in sync.
Noida Area, India
https://media-exp1.licdn.com/dms/image/C4E0BAQEMvQ8E6gXSPA/company-logo_100_100/0/1625820626997?e=1655942400&v=beta&t=Cf59imZByMhBQGGc3pndkq2CClsqo3bZFeHd3fGQZSQ
System Engineer | Senior Database Administrator
Rothemsoft solutions
- Developing & Providing workarounds and resolutions at client side.
- Designing the database structures and writing the database objects in SQL Server 2005 i.e. complex stored procedures, indexes, triggers, views, functions etc
- Troubleshooting using SQL Profiler in Sql Server.
- Database performance tuning and optimization of queries.
- Scheduling database backups with Sql Agent.
Chandigarh Area, India
Database Consultant
Ramco Systems
https://www.linkedin.com/company/ramco-systems
- Troubleshooting using SQL profiler
- Backing up and restoration of databases
- Business study of the inventory and purchasing modules (IMS and POM)
- Training of the key users, development of the cycles which are not directly supported by the Ramco ERP
- Customization work in other modules (AP, AR, GL, MAC, FA, SOM and SHP).
New Delhi, Delhi, India
https://media-exp1.licdn.com/dms/image/C560BAQEkhjs_e_DGzg/company-logo_100_100/0/1519877259383?e=1655942400&v=beta&t=jeYHrZwRDuB0sgy_kiym5kqjL7xmdJUrMxZXZ7JvdMg
Programmer
Bachelor of Technology
Computer Science
https://media-exp1.licdn.com/dms/image/C510BAQFk-1FhZJmk9Q/company-logo_100_100/0/1519869853555?e=1655942400&v=beta&t=RDEWIup5YZZwuBEaVizDn19hFZrTT9QLQzhqb__FIIo
Kurukshetra University
https://www.linkedin.com/school/kurukshetra-university/
Master's degree
Computer Science
https://media-exp1.licdn.com/dms/image/C510BAQFk-1FhZJmk9Q/company-logo_100_100/0/1519869853555?e=1655942400&v=beta&t=RDEWIup5YZZwuBEaVizDn19hFZrTT9QLQzhqb__FIIo
Kurukshetra University
https://www.linkedin.com/school/kurukshetra-university/
Tata Consultancy Services
Service and Commitment Award - 10 years
Tata consultancy Services
On the Spot Award - July 2018
Tata Consultancy Services
Star Team Award - Jan 2017
Tata Consultancy Services
Best Team Award - Nov 2015
Tata Consultancy Services
On the Spot Award - Nov 2015
Tata Consultancy Services
On the Spot Award - Jan 2014
Tata Consultancy Services
On The Spot Award - Aug 2013
Tata Consultancy Services
On The Spot Award - July 2012
Tata Consultancy Services
On The Spot Award - Jan 2012
Tata Consultancy Services
On The Spot Award - Nov 2011
Tata Consultancy Services
On The Spot Award - Jul 2011
Department of Labor & Industrial relations
https://uinteract.labor.mo.gov/benefits/home.do
Passport Seva Project
https://passportindia.gov.in/AppOnlineProject/welcomeLink
IBM
IBM Certified Data Architect - Big Data
IBM
IBM Certified Database Administrator - DB2 10.1 for Linux, UNIX, and Windows certification
IBM
IBM Certified Database Associate - DB2 10.1 Fundamentals Certification
https://www.linkedin.com/in/anupam-rathi-311a314
Edmond, OK
Anupam Rathi
Solution Head - Unemployment Insurance at Tata Consultancy Services
https://www.linkedin.com/in/jainum
Greater Phoenix Area
Utsav Jain
Techno Functional Consultant || Data Analytics || Test Analyst || Business Analyst
https://www.linkedin.com/in/moses-arockiam-a26a7417
Bridgewater, NJ
Moses Arockiam
AWS Public Sector Professional Services Leader
https://www.linkedin.com/in/rahul-singh-khokhar
McLean, VA
Rahul Singh Khokhar
Full Stack Developer | Enterprise Cloud Solution Architect | API Microservices Specialist | Reactive UI Developer
https://au.linkedin.com/in/varun-sharma-2b7857b8
Sydney, NS
Varun Sharma
Senior Technical Business & Data Analyst
2×Microsoft Azure Certified|PCEP
https://in.linkedin.com/in/mohit-mehta-b40aa919
India
Mohit Mehta
Software Engineer at NCR Corporation
https://in.linkedin.com/in/aditya-sharma-5ab92322a
Lucknow
Aditya Sharma
Senior Java Developer
https://it.linkedin.com/in/amandeep-kaur-5366b5162
Novellara
Amandeep Kaur
Disoccupata
https://np.linkedin.com/in/puspa-verma-86439a229
Kathmandu
Puspa Verma
Public Relations Specialist at Soft9
https://in.linkedin.com/in/aakash-kumar-08b750181
Meerut
Aakash Kumar
--
https://it.linkedin.com/in/parveen-kaur-52526683
Parma
Parveen Kaur
Studente presso Università degli Studi di Parma
https://it.linkedin.com/in/giulia-kaur-09193219a
Senigallia
Giulia Kaur
Consulente finanziario assicurativo presso ALLEANZA ASSICURAZIONI
https://it.linkedin.com/in/sarah-locci
Iglesias
Sarah Locci
Full Stack Developer Junior
https://in.linkedin.com/in/bhuvnesh-mishra-7a953071
India
Bhuvnesh Mishra
--
https://it.linkedin.com/in/khushmeet-kaur-7251621b4
Bagnolo Mella
Khushmeet Kaur
Manager presso McDonald's
https://it.linkedin.com/in/jagdip-kaur-8b64131a7
Parma
Jagdip Kaur
impresa simulata presso Università degli studi di Parma
https://in.linkedin.com/in/aakash-deep-6a245593
Delhi, India
Aakash Deep
Technical Services Specialist at IBM
https://www.linkedin.com/in/ayushsood2
Chicago, IL
Ayush Sood
Data Architect at Amazon Web Services (AWS) | AWS 8x Certified Professional
Gaurav Dalal
      
          



            
              
        
              
  

    
        Aakash was my classmate when we were in college. He was very intelligent, hard working and always had great ideas. His approach to resolve problems was extremely good. Till date, I can vouch for his sincerity, his analytical and logical expertise. I highly recommend him as no matter what he does , he will always excel and give his best. Robin Ahuja
      
          



            
              
        
              
  

    
        I was impressed by Aakash’s ability to deal with even the toughest clients – effortlessly. That skill often takes years to develop among consulting professionals, but it seemed to come perfectly naturally to him. Aakash’s ability to handle multiple projects was unlike any I’ve seen before and made a dramatic increase in the productivity level of the company. No matter how tense a meeting, Aakash made sure everyone left with a smile. As a team member or a leader, Aakash earns my highest recommendation.
Liked by Aakash Deep Singh
https://www.linkedin.com/signup/cold-join
Happy Employee Appreciation Day! Today gives us an extra reason to celebrate our EyeCare Partners team members. Together, we live in to our mission…
Liked by Aakash Deep Singh
https://www.linkedin.com/signup/cold-join
Leadership 🔥🔥
Liked by Aakash Deep Singh
https://www.linkedin.com/signup/cold-join
Photo
https://in.linkedin.com/in/aakash-deep-singh-005132220
Kolkata
Aakash Deep Singh
students
https://in.linkedin.com/in/aakash-deep-singh-45828b222
Kanpur
Aakash Deep Singh
Student at Harcourt Butler Technical University
https://in.linkedin.com/in/aakash-deep-singh-lucknow
Lucknow
Aakash Deep Singh
Software engineer at United health group
https://in.linkedin.com/in/aakash-deep-singh-582b62a4
Gurgaon
Aakash Deep Singh
Senior Specialist, AI Garage at Mastercard
DB2 LUW ACADEMY
https://media-exp1.licdn.com/dms/image/C5607AQFeV4vKjdh6VQ/group-logo_image-shrink_200x200/0/1631440188132?e=1647691200&v=beta&t=1LQSpLPin5ZtL7f397WU2hDP-PtJXb0mEgi0EKRmvFQ
https://www.linkedin.com/groups/6727351
KC Area DB2 LUW User Group
https://media-exp1.licdn.com/dms/image/C4E07AQGrlsOHNLO77w/group-logo_image-shrink_200x200/0/1631361695539?e=1647691200&v=beta&t=q98uggLIuMge9qd7Wzw363sHTk4h2z6YgJwtpcCnqzI
https://www.linkedin.com/groups/6808001