ANUPAM THAKUR

As the Principal Architect at Priority Technology Holdings, Inc., I lead the DBA team and oversee the design, implementation, and management of databases and data-related processes. I have more than 19 years of work experience in the database domain, with Oracle certifications in 9i and10g.

I have developed utilities in Python to automate many database tasks.

I have successfully executed multiple complex projects involving database and application migration, performance tuning, security policies, monitoring setups, and data management. I have worked with various technologies, such as Amazon Web Services, MySQL, SQL Server, SingleStore, Oracle RAC, Golden Gate, Active DataGuard, WebLogic, RMAN, and ASP.NET. I am proficient in SQL, PL/SQL, T-SQL, Linux scripting, and RStudio. I enjoy solving challenging problems and delivering innovative solutions that meet the business needs and expectations of our clients.

Principal Database Architect

Priority Technology Holdings Ltd

HYBRID, REMOTE

• Technical Architect / Database Architect, Tech Mahindra Ltd., Mar'17 Onward, Involved in Oracle Database Health Check, Analyzing PL/SQL codes from non-functional perspective, Oracle Database Sustenance Activities, Database Rationalization and Migration Activities, SQL Performance Tuning, Managing & coordinating with different teams like production support, DBAs, delivery team and implementing technologies as per database standard processes, Capacity Planning, Capacity Forecasting, EOSL (Managing End Of Service Life for database & application servers), Implementing Oracle Security Policies and defining processes, Confirming to Non-Functional Maturity standards of all database applications, Code Review and Assurance, Supporting Deployment activities
• Database Administrator, Brictech Software Pvt. Ltd., Feb'16 to Mar'17, Involved in checking MSSQL Database Health Monitoring, Performance Optimization. SQL Performance Tuning., Actively conducted Migration of SQL Server Integration Services Packages into the new MySQL environment., Implemented Database Mirroring, Database Replication, Log Shipping, Knowledge Transition to the Production Support team members to support the database independently., Worked on AWS environment for SQL Server to MySQL Database migration, Have knowledge on choosing AWS Services as per requirements, launching instances, configuring security policy groups, implementing firewall policies, Carried out Database & Infrastructure Migration and Launched application in the new Environment., Significantly designed a Near Real Time Framework to fetch data from MySQL to MsSQL Database. I was the sole owner of the project, Made POC for Database Replication of the Ms SQL database during the Parallel execution for Migration Approach., Successfully conducted Reverse Engineering of an old project developed 10 years ago in .NET and SQL Server.
• Database Administrator, TATA Consultancy Services Ltd., Feb'11 to Feb'16, Was involved into a migration project which used to be a Campaign Marketing Application developed on top of Siebel Analytics with EDW as the backend database, Migrated into IBM UNICA Marketing tool with a new database of 7 TB. The tool was self-designed., Carried out Infrastructure Hardware ordering for different applications as per the standard process of Client's process., Actively involved in Capacity Projection for Database storage and CPU & Memory of database & application servers based on the BAU growth., Skillfully improved backup strategies by reviewing application from functional as well as non-functional perspective., Handled Installation & Configuration of: ORACLE Database Clients, Apache Web Server, Weblogic Server on Oracle Enterprise Linux servers. ORACLE Business Intelligence 11g on Oracle Enterprise Linux servers., Deputed to onsite location - Cardiff, United Kingdom (Jun'14 to Feb'15) for direct interaction with client and to support migration and performing Technical Architecture tasks. Was involved in: Installation of Oracle R and RStudio Administration tool and documenting the installation. Supporting business users to help them in getting access and fixing issues related to database.
• Senior Programmer Analyst, ICRA Techno Analytics Ltd., Jun'07 to Jan'11, Worked as Production Support team member for Oracle Database environments, Was accountable for solution life cycle development, to be deployed in EDW production database starting from E2E (end-to-end) design, Solution Design, non-functional design review, LLD (Low Level Diagram) component review, code review, advising performance tuning possibilities, Performance Scalability Testing, deployment and then reactive tuning., Deputed to onsite location - Los Angeles, United States of America for direct interaction with client to know business requirements and development - Jan'08 to Apr'08.
• Web Developer, City Tech Solutions Pvt. Ltd., Jul'05 to Jun'07, Worked as a PHP and ASP.NET programmer to build Web Applications., Gathering Client requirements and designing/coding the application pages., MySQL and MSSQL (SQL Server) Database schema design and development.
• Java & ASP Programming, Synergy Systems, Aug'04 to Jun'05, Worked as a Java and ASP programmer., Interaction with clients and collecting requirements for ASP and Java applications, MSSQL (SQL Server) Database schema design and development.

• Strategy Planning
• Security Assessment and Implementation
• Performance Engineering
• Application Development
• Solutions Architecting
• Business Vision & Growth
• Team Management
• Quality Management
• Implementation of Best Practices
• Risk Management
• Resource Management

Priority Technology Holdings Ltd., 4 years 2 months

MySQL, MongoDB, MongoDB Atlas, RedShift, AWS RDS, AWS EC2, 

Data Archival, Database Optimization, SQL Query Tuning, Documentation - SOP, Runbooks, Monitoring & Alerts, Backup & High Availability Design, Migration, Upgrades etc.

Tech Mahindra Ltd., BT Global Services, British Telecommunication, Telecommunication, 1 year 2 months, Oracle 11g, Oracle 12c, OBI, Oracle Enterprise Linux, JMeter, Database Sustenance Activities, SQL Performance Tuning, Database Health Check, Technical Review & Assurance, Assessing Non-Functional Maturity for Applications 

Brictech Software Pvt. Ltd., OrangeSoda, Deluxe Inc USA, Analytics, 1 month, Windows Server, SQL Server Database, ASP.NET, Reverse Engineering of a 10 years old .NET application by using SQL Server Profiler and finding opportunities to resolve performance problems of the application by SQL Performance Tuning Brictech Software Pvt. Ltd., PsPrint, Deluxe Inc USA, E-Commerce, 1 year, Amazon Web Services, SQL Server Database, SSIS, SSAS, Windows Server, Database Migration, Database Development, ETL development, Technical Lead managing team of 10 people, Deployment, Post-Deployment activities, Production Support, Database Optimization 

TATA Consultancy Services Ltd., BT Retail Consumer, British Telecommunication, Telecommunication, 60 months, OEL, Oracle 11g, IBM Campaign, Marketing Tool (Unica), Apache, Weblogic, Oracle Enterprise R (Big Data), Database Support, Technical Assurance, Performance Tuning & Database Administration, Software Installations, Oracle Database Client, Apache & Weblogic Installations & Support. TATA Consultancy Services Ltd., BT Retail UKBS & Consumer, British Telecommunication, Telecommunication, 61 months, Oracle 10g, Linux Shell Scripting, Non-Functional Review of Codes, Technical Assurance, SQL/PL.SQL Tuning, Database Health Check

 ICRA Techno Analytics Ltd. (Currently Nihilent Analytics), Production Support & Performance Tuning, National Payment Network, Banking, 40 months, Linux, Java, Oracle 10g, Production Support, DBA related tasks and all types of DB related production issues, writing PL/SQL ICRA Techno Analytics Ltd., Multiple Bank Facility, National Payment Network, Banking, 12 months, Linux, Java, Oracle 10g, Writing PL/SQL ICRA Techno Analytics Ltd., Migration of Customers from salesforce.com to cp.nationalpayment.net, National Payment Network, Banking, 10 months, Linux, Java, Oracle 10g, Writing PL/SQL