•Managing and administering SQL Server (2016, 2019, 2022), database instances in Azure cloud (IaaS)•Lead the SQL Server storage transition activity, recommended addition of new volumes, type of IOPs required, block size, and allocation of over 150 databases on new volumes guaranteed contention free concurrent IOs. IO bound databases movement to dedicated disk controllers resulted in 75x improvement IO•Implemented horizontal table partitioning to overcome data warehouse large data deletions overheads by introducing partition truncation for specific partition key value. ETL workload improved by 100x• Implemented a robust backup strategy to overcome flaws of legacy backup policy. Differential backup introduced for large databases while their full backups frequency moved to weekly basis. An overall 100x backup time improved on weekdays created more room for ETL workloads•Implemented a new process to proactively monitor SQL Server production hour stored procedure executions. The process outcome a daily huddle of product leads to discuss and assign stories to respective stockholders. SQL Server Extended Events has been utilized to extract SP execution data and insights have been gathered in excel•Implemented new index maintenance task that divided the rebuild of indexes of partition and non-partition tables into two separate tasks. Only partition with data changes is selected for index rebuild. 50x faster index rebuild achieved.•Implemented table statistics maintenance task by segregating incremental and non-incremental statistics to two different maintenance tasks. This improved the overall task by 30x •Recommend hardware resources for existing and new SQL Server instances, Azure SQL DBs, Azure managed Instances, ADF and Synapse analytics dedicated SQL Pools•Created a robust database alerting system that timely alerts database locking, agent job failures, long running queries, CPU above baseline peaks, backup completion report, login failures

• Lead the enterprise data center transition/migration project from databases perspective and managed the SAN allocation strategy for all the enterprise SQL Server databases. Prepared detail checklists, worksheets, configuration documents, implementation work flows, duty rosters for DBAs, Cluster architecture diagrams, replication architecture diagrams and other related documents• Designed and implemented 5 node active/active load balanced and highly available SQL Server 2012 FCI cluster.• Implemented database Replications in SQL Server 2005, 2012 for High Availability, DR and Reporting• Redesigned a thorough backup and recovery strategy for all major production systems. This initiative involved the design and development of scripts used for physical backups. Also included in this effort was the development of various recovery strategies that included media failure, user failure, and partial and complete recovery• Established the Database Administrators Procedures. This outlines all standards for the DBA Group including installing SQL Server, creating databases, DBA tools, administration and monitoring, naming standards, coding standards for T-SQL, policies, practices and procedures• Automated monitoring infrastructure by using windows power shell and T-SQL scripts. This allowed our operational DBA team to efficiently gather database metadata, exceptions, and performance statistics of enterprise wide SQL Server instances.• Implemented high level security policies for user accounts, passwords, roles and privileges across the enterprise database environments• Finalized and documented several business rules for data integration tasks that led to designing and development of SSIS packages and related ETL scripts.database physical/logical structure as required to overcome space issues.• Database capacity palming• MIS reporting related to tax collections, tax shortfalls, tax withheld, sector and region wise summaries and reports for annual national budgets

• Managed Sun Solaris 8 Operating system on Sunblade2500 system.• Installation of Sun Solaris 8 OS/ patches, HP Open View 7.0/ patches, and NEC Pasolink Network Management System (PNMS).• Pasolink network trouble shooting, link configuration and Active and History Alarms reporting with the help of PNMS.• PNMS network designing with help of NEC Net Config Tool and Path Loss. • On site PNMS link configuration, trouble shooting and Net Configuration deployment with help of NEC Pasolink Network Management Terminal (PNMT)• PNMS integration with the Upper SNMP NMS Manager (Hp TEMIP). • Managed the preparation of daily task schedule for the all the regional PNMS implementation teams• Managed the site access approvals for the PNMS implementation team’s sites visits. • Managed and coordinated in DXX and Lease Line connectivity between PNMS regional networks• Managed the deployment of PNMS implementation filed teams according the regional needs• Managed the NMS hardware and cabling requirements for the PNMS network at every BTS, BSC, MSC and at customer NOC• Managed the link visibility on the NMS server in the Customer NOC and send teams to resolve visibility issues• Assisted the teams for resolving critical issues by personally visiting the sites• IP addresses management across 40 plus regional subnets of over 8000 Network Elements (NE)• Managed communication with customer for the provisioning of high level NMS equipment like Router and switches for the NMS interconnect• Managed preparation and dissemination of weekly and daily NMS visibility progress reports for customer

• Provided the Seasonal support to the Data Entry project of 1.4 Million Income Tax Returns at the National Data Entry Centre. Resolved data entry issues of data entry clerks, EDP supervisors and document scanning staff.• Generated and distributed daily, weekly and monthly data entry progress reports using ad-hoc T-SQL scripting• Generated and distributed domain specific reports related to tax collections, tax shortfalls, tax withheld, sector and region wise summaries and reports related to annual national budget• Designed and implemented database backup and recovery plan. • Maintained and administrated SQL Server 2000 Database that include security implementation, performance tuning and capacity planning.• As a team player took part in the data analysis project of 1.2 million Income Tax Returns for tax year 2004. Performed the data cleansing according to the business rules. Specific tasks included preparing, testing, and implementing of data quality control and business specific validation checks. Processing and reorganizing data to and fro databases and/or files, and preparing data management procedures

• Performed Oracle database management tasks for Oracle7, 8i on IBM AIX, tasks included application support, database objects management, database security and access control, MIS reporting via SQL Pluss and developer 2000 reports, and database optimization; supported developers with Oracle-related projects by creating new triggers, columns, tables, sequences and roles when requested• Managed database and OS backups and recovery; managed AIX user privileges & permissions and files & directory access permissions• Provided technical support to the annual regional data entry project of seventy thousand income tax returns• Performed in-depth cross database analysis between Income Tax and Withholding Agents databases for new taxpayers identification/registrations • Carried out electronic tax audits; the task required Data Migration & Integration; Oracle SQL & PL/SQL scripting and Oracle Report Builder 6i report designing.