Pankaj Kumar Chaurasia
Lead Software Engineer
Ghaziabad
Summary
Complex problem-solver with analytical and driven mindset. Dedicated to achieving demanding development objectives according to tight schedules while producing impeccable code.
Overview
13
13
years of professional experience
7
7
years of post-secondary education
Work History
Lead Software Engineer
TSYS Card Tech Pvt Ltd India LLP
Noida Sector-62
10.2022 - Current
- Leading a team to Migrate SQL Server On Prem Database to RDS for SQL Server Cloud Migration
- Working one AWS cloud technologies i.e. RDS, EC2, VPC, S3, Active Directory, Kerberos Authentication
- Resolving any blocker they face during cloud migration
- Setup RDS Cloud infrastructure for MS SQL Server.
- Working on Always on for On Prem SQL Server Platform
- Performing Code Reviews.
- Processing the Team Member on-boarding Processing.
- Documented Team Member onboarding and all the skills required for the other team members to help them work quickly on anything.
Distributed Database Specialist
TSYS Card Tech Pvt Ltd India LLP
Noida Sector-62
07.2021 - 09.2022
- Worked on SQL Server Upgrade from 2012 to 2016.
- Worked on Data Centre Migration.
- Worked on Access Model for SQL Server.
- Worked on Performance Tuning.
- Worked on Proxy Account for SQL Server Agent Job
- Worked SSIS and TSQL
DISTRIBUTED DATABASE ADMINISTRATOR SENIOR G2
TSYS Card Tech Pvt Ltd India LLP
Noida Sector-62
12.2019 - 06.2021
- Created and implemented database designs and data models.
- Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
- Created and updated database designs and data models.
- Tested programs and databases to identify issues and make necessary modifications.
- Supported SQL Server Upgrade form 2008 R2 to 2016 for several products.
- Worked on TSQL, Stored Procedures, Functions, Triggers, Views, SSIS, SSRS and Performance Tuning.
- Supported PL/SQL environments.
- Worked on automation using python and Jenkins.
Distributed Database Administrator Senior G1
TSYS Card Tech Pvt Ltd India LLP
Noida Sector-62
05.2017 - 11.2019
- Database Administration, Database Development, Database Monitoring, SSIS
- Worked Independently on the complex code
- Worked on SQL Server technologies like TSQL, SSIS, Performance Tuning.
- Production Support
- Facilitated training on SSIS.
Sr. Database Developer
Smart Utility Services
Noida Sector-62
12.2015 - 05.2017
- Requirement Analysis, Database development, Performance Tuning, Unit testing, Job Monitoring, Administration
- Projects: SCM Base
- Technologies Used: TSQL, Stored Procedures, Functions, Views, Tables, Triggers, Cursors, Agent Jobs, SSIS
Software Developer
ISC Software Pvt. Ltd, CoreCard Software Inc
Bhopal
03.2011 - 12.2015
- Collaborated with project managers to select ambitious, but realistic coding milestones on pre-release software project development.
- Collaborated on stages of systems development lifecycle from requirement gathering to production releases.
- Revised, modularized and updated old code bases to modern development standards, reducing operating costs, and improving functionality.
- Updated old code bases to modern development standards, improving functionality.
- Technologies Used: TSQL, DDL, DML, Tables, Views, Stored Procedures, Triggers, Cursors.
- Worked on Performance Tuning
- Supported Database Conversion
Education
Master of Computer Application (MCA) - Information Technology
Thakral College of Technology
Bhopal 07.2008 - 06.2011
Bachelor of Computer Application (BCA) - Information Technology
Makhanlal Chaturvedi National Journalism University
Chhatarpur, MP 07.2004 - 06.2007
XII Standard (Higher Secondary) - Mathematics
Govt Nehru Higher Secondary School
Maharajpur, MP 07.2003 - 03.2004
X Standard (High School) -
Maharishi Dayanand High School
Maharajpur, MP 07.2000 - 03.2001
Skills
Databases: SQL Server 2005/2008/2012/2014/2016
AWS Tools: RDS, EC2, DMS, S3, Active Directory, VPC, IAM, Security Groups
ETL: SSIS, SSRS, SSAS
Database Administration: Index Maintenance, Replication, Always On, DB Backups
Performance Tuning: Query Optimization, SQL Profiler
SQL Upgrade/Migaration: On Permise to On Premise Migration, On Premise to Cloud Migration
Automation: Python, Jenkins, PowerShell, SQL Agent Jobs
Other Technologies: Bitbucket, Jira, Jenkins, Confluence
Timeline
Lead Software Engineer
TSYS Card Tech Pvt Ltd India LLP
10.2022 - Current
Distributed Database Specialist
TSYS Card Tech Pvt Ltd India LLP
07.2021 - 09.2022
DISTRIBUTED DATABASE ADMINISTRATOR SENIOR G2
TSYS Card Tech Pvt Ltd India LLP
12.2019 - 06.2021
Distributed Database Administrator Senior G1
TSYS Card Tech Pvt Ltd India LLP
05.2017 - 11.2019
Sr. Database Developer
Smart Utility Services
12.2015 - 05.2017
Software Developer
ISC Software Pvt. Ltd, CoreCard Software Inc
03.2011 - 12.2015
Master of Computer Application (MCA) - Information Technology
Thakral College of Technology
07.2008 - 06.2011
Bachelor of Computer Application (BCA) - Information Technology
Makhanlal Chaturvedi National Journalism University
07.2004 - 06.2007
XII Standard (Higher Secondary) - Mathematics
Govt Nehru Higher Secondary School
07.2003 - 03.2004
X Standard (High School) -
Maharishi Dayanand High School
07.2000 - 03.2001