• Develop goals and strategies to ensure the IT department runs smoothly and effectively.• Direct and establish IT-related projects.• Senior Architect to design Database & Data Security Solutions for Azure Database Environment• Assess, Manage Data Security & Privacy of Mission Critical MS SQL Database enviroments.• Working on Major Initiatives of the Business Development Team like 'New Client Development', 'Training Development', ' Proposal Development', ' Intellectual Capability Development' and other such initiatives• Identify the prospective issues in the Azure Database Migration and suggesting feasible Solutions to Clients• Transitioning new technical projects and ensuring smooth go-live for Azure Operations. Executing technical feasibility assessments, solution estimations for Datacenter Migration with Public and hybrid Cloud migration and deployment. • Design, development, and implementation of large, complex database systems supporting one or more business and/or technology areas, including OLTP and Data Warehouse using MS SQL Server & agile practices and the implementation of processes, methodologies and techniques.• Creating, validating and reviewing solutions and effort estimate for data center migration to Azure Cloud Environment Conducting Proof of Concept for Latest Azure cloud-based service. (Digital Foundation Project)• Documentation of Azure Processes for Company's future use• Implemented the ITIL standard model of RDBMS for the DBA teams: Jointly co-developed SLAs and KPIs with vendors to monitor and support Service Delivery, Service of Excellence and People for Managing and Maintaining Database systems• Partnering with NOC to manage critical business metrics (RPI, C2IR etc.) using Enterprise BI dashboards for lead generation sales & marketing business.

• Working as a Senior Database Architect to design Automation Solutions for Microsoft SQL Environment.• Working on Major Initiatives of the Business Development Team like 'New Client Development', 'Training Development', ' Proposal Development', ' Intellectual Capability Development' and other such initiatives.• Identify the prospective issues in the Azure Migration and suggesting feasible Solutions to Clients.• Transitioning new technical projects and ensuring smooth go-live for Azure Operations. Executing technical feasibility assessments, solution estimations for Datacenter Migration with Public and hybrid Cloud migration and deployment.• Design, development, and implementation of large, complex database systems supporting one or more business and/or technology areas, including OLTP and Data Warehouse using MS SQL Server & agile practices and the implementation of processes, methodologies and techniques.• Creating, validating and reviewing solutions and effort estimate for data center migration to Azure Cloud Environment. Conducting Proof of Concept for Latest Azure cloud-based service (Digital Foundation Project).• Assist customers in simplifying the Architecture by Automation using JSON Templates and PowerShell.• Documentation of Azure Processes for Company's future use.• Implemented the ITIL standard model of RDBMS for the DBA teams. Jointly codeveloped SLAs and KPIs with vendors to monitor and support Service Delivery, Service of Excellence and People for Managing and Maintaining Database systems.• Partnering with NOC to manage critical business metrics (RPI, C2IR etc.) using Enterprise BI dashboards for lead generation sales & marketing business.

• Senior Architect to design Database & Data Security Solutions for Azure Database Environment• Assess, Manage Data Security & Privacy of Mission Critical MS SQL Database environments.• Identify the prospective issues in the Azure Database Migration and suggesting feasible Solutions to Clients• Transitioning new technical projects and ensuring smooth go-live for Azure Operations. Executing technical feasibility assessments, solution estimations for Datacenter Migration with Public and hybrid Cloud migration and deployment.

• Responsible for customer data service management, project/program management, pand Database infrastructure availability.• Design, development, and implementation of large, complex database systems supporting one or more business and/or technology areas, including OLTP and Data Warehouse using MS SQL Server & agile practices and the implementation of processes, methodologies and techniques.• Implemented the ITIL standard model of RDBMS for the DBA teams: Jointly co-developed SLAs and KPIs with vendors to monitor and support Service Delivery, Service of Excellence and People for Managing and Maintaining Database systems• Partnering with NOC to manage critical business metrics (RPI, C2IR etc.) using Enterprise BI dashboards for lead generation sales & marketing business.• Managed database engineers/ administrators and operations teams on MS SQL Server environments across multiple sites and offshore teams.• Participated in Internal and external audit for Customers and mitigated the findings.

• Handling Multi National clients Across North America, Europe, Singapore, Japan, Australia and India.• Lead DBA team of over 10+ MS SQL Server DBA professionals on large complex database projects.• Provide support for database administration, database migrations and disaster recovery solutions for $1M relational databases.• Advised on database management strategies and best practices.• Provide SQL support including SQL query creation and tuning.• Tutoring and Mentoring junior database administrators and new features in application and database sides in MS SQL Server 2008, 2008 R2.• Providing pro-active management of systems to prevent unnecessary system downtime and to ensure data driven applications are performing and operating with the latest available data.

• Supporting the Company’s internal database infrastructure and providing the day-to-day administration needed for production systems.• Diagnosing and resolving any technical issues with systems or servers as and when failures occur.• Provide a point of reference for methods to resolve issues. Utilize a knowledge of problem resolution and SQL Server knowledge to provide support to the team when troubleshooting live issues.• Providing pro-active management of systems to prevent unnecessary system downtime and to ensure data driven applications are performing and operating with the latest available data.• Reviewing and maintaining production systems to ensure they meet the demands of the business in terms of capacity and reliability.

• Responsible for SQL Related Performance/Implementation issues, installation, configuration & up- gradation of SQL server 2008, 2005, 2000 version databases.• Suggested Disk Capacity, Processors and Memory based on Capacity planning for new project implementation databases.• Worked with Performance Tuning of Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, user defined data types and functions for various project.• Implemented database standards and naming convention for the database objects.

• Involved in installation and configuration of SQL server 2005/2000. Applied patches and service packs & Created Data models using Erwin Data modeler for various clients.• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions. • Responsible for General Database Administration and Performance tuning.

• Involved in installation and configuration of CatalogStudio 2008, 4.1.2 Databases for various clients using SQL Server 2005 & 2000. • Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for CatalogStudio 2008. • Involved in Analysis and Design Documentation, User requirements and maintained good documentation.

• To perform daily, weekly, monthly backups of SM Profiler database through automated scripts• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions for SM Profiler.• Automated jobs for reports of stocks, contracts, customer details, vendor details etc…• To execute data transformation packages to transform various formats of data into SQL Server