Summary:

• Microsoft Certified Professional with over 15 years IT Experience and around 12 years as Database Solution Architect including around 6 years as a Microsoft ERP Dynamics AX System Architect/Administrator with demonstrated expertise in installation, configuration, administration and Production Servers maintenance of Microsoft ERP Dynamics AX 2012 R3/R2/2009 and MS SQL Server 2014/2012/08/05/2000 Active/Passive Cluster/dispersed, Always On and Oracle 11g/10g/9i and Worked as a part of 24x7 Total Technical Supports
• Responsible to Plan, direct and oversee full life cycle Implementation of Microsoft ERP Dynamics AX 2012 R3/R2/2009 and Database Infrastructure design and management Operation, leading projects, cost saving and meeting goals. Implementing IT procedure policies and best practices.
• Implementation and administration of Microsoft ERP Dynamics AX Axapta 2012 R3/R2//2009/4.0 on SQL Server, AOS Cluster/Load balancing, Enterprise portal EP load balancing reporting extensions and analysis Service extension, Setting up AIF, DMF and workflows.
• Expertise and Interest include Database infrastructure Design, Administration, Performance Analysis and troubleshooting of Production Complex Databases,
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large VLDB and Complex Databases.
• Data Design and Development on SQL Server system in OLTP/OLAP environment.
• Design Relational Databases model and Implementation as per business needs.
• Successfully Designed and Implemented Windows Server Cluster with Microsoft SQL Server Active/Passive clusters with AlwaysOn by using HP/Compaq, IBM SAN, NetApp SAN and EMC.
• Successfully Designed, Implemented and administrated Oracle 11g/10g/9i, RAC, Data Guard on UNIX/LINUX and Windows. Used SQLPLUS, PL/SQL, RMAN utility and SQL Tuning Advisor.
• Experience in extracting and transforming data using SSIS and DTS Import/Export Data, Bulk Insert, BCP and DTS, Oracle Exp/Imp, 10g Data Pump and Oracle SQL Loader Utilities.
• Experience in Database administration activities for SQL Server and Oracle Security creating users, roles, and assigning permission to them .
• Experience in Performance Tuning, Query Optimization and Client/Server Connectivity.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Installed and configured IIS 7.0/6.0/5.0 for Intranet and Internet websites in Windows 2012/08/3/00 Servers. Successfully Implemented, supported and Administrated Microsoft SCOM monitoring system. Performance, Monitoring Critical Alerts and Notifications.
• Active Directory Domain, Domain Controller and one way trust or two way trusts.
• Designed and Implemented Backup and Restore utilities and Disaster Recovery in various platforms. Organized Exceptional and Professional Documentations, Trainings, Presentations and Oral/Written Interpersonal Communication Skills.

Technical Skills:

Database : Microsoft SQL Server 2012/2008/2005/2000, Oracle 11g/10g/9i

and Sybase ASE 15/12.5

Server OS : Ms Windows Server 2012/2008/2003/2000, SUN Solaris 10/9,

Redhat Enterprise Linux 5/4 and IBM AIX 6/5 linux/Unix.

Desktop OS : MS Windows Vista/XP/2000/NT 4.0/ and Ms-Dos 6.22.

ERP Applications : Microsoft Dynamics AX 2012 R3, R2/2009/4.0, Microsoft CRM 4.0,

Siebel CRM 8/7, SharePoint 2010/2007/3.0 services.

Management : Microsoft Operation Manager 2008/05, Ms Windows Update Service

Backup Software : MS Backup, VERITAS, CommVault and ARCserve.

Virtualization : Microsoft Hyper-V 2012/08, VMware ESX Server 5/4

Hardware : Servers: Compaq/HP Proliant and Blades Servers, IBM X series

Servers and Dell Power Edge Servers. HP Storage and EMC Storage.

Work Experience:

Confidential

Job Role: Dynamics AX Architect

Responsibilities:

• I am responsible to Design and Implement full life cycle of Microsoft ERP Dynamics AX 2012 R3/R2 Infrastructure/Microsoft SQL Server 2012/2008, Implementation and administration by using Best Microsoft practices and Involved in the Data center Migration.
• Involved in Dynamics AX 2012 R2/R3/ERP capacity planning for DENTSPLY.
• Successfully designed and Implementation of Microsoft Dynamics AX 2009/2012 R3/R2 ERP system on Microsoft SQL 2012/2008 Cluster environment with AlwaysOn.
• Dynamics AX AOS/Enterprise portal load balancing, administration and performance and optimization. Expertise in Dynamics AX administration and Performance troubleshooting.
• Designed and Implemented Always On for Dynamics Databases and other Application Databases.
• Microsoft Reporting Services and Analysis services extension configuration and troubleshooting.
• Successfully Designed and implemented Microsoft SQL 2014/2012 4 NODEs with AlwaysOn and Multi node cluster/multiple instances on Microsoft Windows 2012/2008 R2 enterprise.
• Design and implemented Enterprise SharePoint environment for Dynamics AX enterprise portal, SSRS reporting services extension and SSAS analysis services integration extension.
• Dynamics AX Security Development and customization. Deploying and configured AIF/DMF.
• Develop, test and deployment Legacy Data migration to Dynamics AX using Data migration framework and Data loading. Setting up Workflows.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Involved in database capacity planning for DENTSPLY ERP databases Dynamics AX, SharePoint, Siebel Analytics and BizTalk Servers .
• Responsible for ensuring the reliable performance of ERP systems, Monitor server performance, AX SQL Tracing and finding bottleneck, setting up Performance counter for Dynamics AX and SQL Servers.
• AX development codes move on different environment by Utilizing AX model Store, AX Model Files and XPO moves to migrate code. Refreshing Dev, Test and Staging environment from Production.
• Installation of add-ons, updates and Hotfixes
• Implemented database maintenance plan for Dynamics AX, SharePoint and Siebel Analytics SQL Servers.
• Implemented database maintenance plan for BizTalk Servers
• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support. Manage AX user and security groups
• Performed all aspect of database administration, table partitioning, backup strategies, recovery, and replication for SQL server 2014/12/08/05.
• Analyze some of the long running slow queries tune the same to optimize application and system performance by using DMVs/DMFs. Used system stored procedures and DBCC commands.
• Rebuilding the Indexes at regular intervals for better performance. Tuned SQL queries and stored procedures using SQL Profiler and database tuning advisor.

Environment: MS SQL Server 2005, T-SQL, Win 2003/Windows Server 2008 R2, VB, ASP, Dynamics AX 2012 R3, R2, 2009 and Siebel Analytics.

Confidential

Job Role: Sr. ERP System Architect/Database Architect.

Responsibilities:

• I am responsible for Database Infrastructure designing, best practice recommendation, Implementation of Microsoft SQL 2008 clusters, administration and troubleshooting for various projects and applications.
• Successfully Designed, Implemented, and Administering Microsoft Windows Server 2008 and 2005 Cluster and Microsoft SQL Server 2008 and 2005 clusters.
• Design and Implementation of highly available Microsoft Dynamics AX 2009 ERP system on Microsoft SQL 2008 Cluster environment.
• AX AOS/Enterprise portal load balancing, administration and performance and optimization. Ms Reporting Services and Analysis services extension.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies. Building SQL Servers and cluster standards and security Standards.
• Worked on Oracle 11/10g servers running in RedHat Enterprise and performed administration. Backing and recovery of databases. RMAN utility, SQL Tuning advisor, Performance monitoring and tuning.
• Monitor database log files, data block corruption, segment fragmentation.
• SQL Server and Oracle Performance issues, security threat, locking and blocking issues, resource issues CPU, Memory and I/O. Manage high volume transactional tables and indexes, reorganization/rebuild indexes and query optimization.
• Working on Idera SQL safe and Idera Diagnostic manager.
• Worked on migration from Ms SQL Server 2000/2005 to Ms SQL Server 2008 clusters.
• Microsoft Hyper-V and VMware ESX virtualization used for consolidation of database servers and application servers.
• Environment: MS SQL Server 2008/05/00, Oracle 11g/10g , Win 2008/03 RedHat 5, IIS, FTP, DTS, SSIS, MQ Series, WBI VB, ASP, XSL, XML Web Services, JavaScript, CSS, IIS 7/6 and SSRS and SSAS.

Confidential

Job Role: Sr. Database Administrator

Responsibilities:

• Successfully Designed, Implemented, and Administering Microsoft Windows Server 2008 Cluster and Microsoft SQL Server 2008/2005 Active/Passive clusters.
• Worked as a Database Administrator and I was responsible for requirement analysis, design, document, development, enhancement and support of MS SQL Server databases and Oracle Database.
• Involved in Architectural design for the databases and database tables and capacity planning.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Implementation of Oracle 10g on AIX Servers, performed administration and performance monitoring.
• Oracle database backup and recovery, refreshing databases in Development, test and pre-prod environment. RMAN utility, 10g Data Pump and Exp/Imp, SQL Tuning advisor. Database security and standards.
• Implemented and administrated Oracle data guard for disaster recovery.
• Designed and developed SQL Server SSIS for data migration and ETL for loading data to data warehouse.
• Implementation and administration of Microsoft SSAS 2008/2005and SSRS 2008/2005
• Worked on SQL Server Data Partitioning, Snapshot replication and transactional replication.
• Tuned SQL queries and Stored procedures using SQL Profiler and Index Tuning Wizard.
• SQL Server and Oracle Performance issues, security threat, locking and blocking issues, resource issues CPU, Memory and I/O. Manage high volume transactional tables and indexes, reorganization/rebuild indexes and query optimization.
• Verified backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with other department's team.
• Responded to trouble tickets assigned and fixed any database issues promptly, worked on projects that initiated by higher management.
• Worked on VMware virtualization in development and testing environment.

Environment: MS SQL Server 2008/05/00, Oracle 10g , Win 2008/03 AIX Unix, IIS, FTP, MQ Series, SAP, WBI VB, ASP, XSL, XML Web Services, JavaScript, CSS, IIS 7/6, SSRS, SSAS SSIS.

Confidential

Job Role: SQL Database Administrator Lead

Responsibilities:

• Successfully Designed, Implemented and administration of MS Windows Server 2003 and MS SQL Server 2005 for production and staging.
• Designed and supported to build Data Warehouse Star Schema by using Erwin Data Modeler.
• Designed and developed SQL Server Integration Services SSIS to pull full monthly and daily incremental data from Oracle Database.
• Implemented SQL Server Security, Backup and Restore policy. Scheduled jobs and alerts using SQL Server Agent.
• Designed and developed ETL for loading data from staging to Data Warehouse. Scheduled SSIS packages.
• Developed T-SQL stored procedures as a part of database maintenance plan for new SQL Server 2005.
• Performed all aspect of database administration, tuned SQL queries and stored procedures using SQL Profiler and Database Engine Tuning Advisor DTA .
• Supported for designing and implementation of Cognos Reporting.

Environment: MS SQL Server 2005, T-SQL, Win 2003, IIS, FTP, DTS, SSIS, Oracle 9i, Web Services, IIS 6.0 and Cognos 8 Reporting.

Confidential

Job Role: Database Administrator Consultant

Responsibilities:

• Successfully Designed, Implemented, and Administering Microsoft SQL Server 2005 Active/Passive clusters on Microsoft Windows Server 2003 Cluster.
• Worked MS SQL Server 2005/2000 Administrator and I was responsible for requirement analysis, design, document, development, enhancement and support of MS SQL Server databases.
• Worked on Oracle 10g on AIX Servers and performed Installation, administration and performance monitoring.
• Oracle database backup and recovery, refreshing databases in Development, test and pre-prod environment. RMAN utility, SQL Tuning advisor. Database security and standards.
• Oracle database security and Users authentication. Tablespaces, data files, SQL/PLUS and PL/SQL.
• SQL Server and Oracle Performance issues, security threat, locking and blocking issues, resource issues CPU, Memory and I/O. Manage high volume transactional tables and indexes, reorganization/rebuild indexes and query optimization.
• Involved in Architectural design for the databases and database tables and capacity planning.
• Designed and developed SQL Server Integration Services SSIS for data migration and Extracting and transforming data. Worked on SSAS and SSRS.
• Rebuilding the Indexes in Oracle and SQL Server at regular intervals for better performance.
• Tuned SQL queries and Stored procedures using SQL Profiler and Index Tuning Wizard.
• Verified backups and error logs on the servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with other department's team.

Confidential

Job Role: MS SQL Server DBA/Dynamics AX DBA

Responsibilities:

• Successfully Designed, Implemented, and Administered Microsoft Windows Server 2003 Cluster and Microsoft SQL Server 2005 Active/Passive cluster.
• Implementation and administration of Microsoft Dynamics AX.40 on Microsoft SQL 2005 Cluster.
• Dynamics AX4.0, AOS with NLB, enterprise portal, business connector configuration, User management and security standards and performance tuning.
• Creating and Maintaining Databases, Adding Users, Roles, and Groups and assigning privileges according to the project needs.
• Created Database Maintenance plans, Managed Database Structures, Disk Spaces, DTS packages, scheduling Database Backups, Restoring Databases and Maintained data accuracy and consistency.
• Migrated DTS objects to SQL Server Integrated Services SSIS environment
• Setup transactional and snapshot replication, Implemented log shipping technology. Worked on Data partitioning and performance tuning.
• Analyzed, fine-tuned and optimized MS SQL Server Applications by using Performance Monitor, setting up traces using SQL Profiler.
• Provided support to the Data Center team in their development and truncated the transaction logs to check the space of the exponentially expanding databases.
• Performed upgrade of OS, Applications file system expansions as and when required. Used VB scripts.
• Managed the production database servers Taking daily backups by using VERITAS Net backup.
• Daily basis reviewed performance monitoring and Windows and SQL Event Logs and System Logs.
• Performed troubleshooting and maintained H/W and networking problems
• Tested Windows and SQL Server critical and security Patches on test LAB and installed in Production environment.

Environment: MS SQL Server 2005/2000, Windows 2003/2000 Servers, IIS, FTP, Oracle 9i, SQL Profiler, VERITAS, MS MOM 2005 Server, ASP.Net, C .Net, ADO.Net, XML, XSL, XML Web services and Network Support.

Confidential

Job Role: Database Administrator.

Responsibilities:

• Responsible for SQL Databases on 4 Cluster Active/passive servers, Implementation and administration of Active Directory logins and SQL Logins, Roles and Authentication Modes according to the requirement for various categories of users and groups.
• Successfully Designed, Installed, configured and Administered Microsoft Windows Server 2003 Cluster and Microsoft SQL Server 2005 Active/Passive cluster.
• Installed, configured and administered and troubleshooting Oracle 10g high availability on SUN Solaris.
• Monitor database log files, data block corruption, segment fragmentation.
• Backing and recovery of Oracle databases. SQL/PLUS, PL/SQL, RMAN utility, SQL Tuning advisor, Performance and tuning, DBCC.
• Oracle and SQL server databases performance issues, security threat, locking and blocking issues, resource issues CPU, Memory and I/O. Manage high volume transactional tables and indexes, reorganization/rebuild indexes and query optimization.
• Working data partitioning for new SQL server 2005 databases and created partition function, partition scheme mapped to a partition function and created the table on the partition scheme.
• Migrated Microsoft SQL Server 2000 to Microsoft SQL Server 2005. Migrated DTS objects to SQL Server Integrated Services SSIS environment. Migrated Microsoft Analysis Services to SQL Server Analysis Services SSAS
• Designed and Implemented Sybase ASE server and performed administration. Backing up and restoring database. Creating SQL logins and giving appropriate permission. Monitoring database spaces.
• Managing Sybase and performance monitoring and disaster recovery.
• Designed and implemented Backup plan and disaster recovery strategies
• Involved in trouble shooting and fine-tuning of databases for its performance and high availability.
• Maintained Reporting services on MS SQL 2005/2000 platform.
• Implemented and administrated transactional and snapshot replication.
• Day to Day basis reviewing Performance monitor and Event logs on all Oracle Server and SQL Servers.
• Verify backups and error logs on the SQL servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.

Environment: Oracle 9i/10g, MS SQL Server 2005/2000, Sybase ASE 12.5, Sun Solaris, Windows 2000/2003, IIS, FTP, Siebel, ASP.Net, C .Net, ADO.Net, XML, XSL, XML Web services, JavaScript, CSS, IIS 6.0 and Crystal Reports.

Confidential

Job Role: Database Administrator and System Administrator

Responsibilities:

• Worked on Database Administration and provided 24x7 supports in production Environment. Managed a team of 5 Network Support Engineers.
• Successfully designed and implemented and administrated Windows 2003/2000 Cluster and Microsoft SQL Server 2000 Active /Passive cluster by using HP Storage Area Network.
• Administrated Axapta 3.0 and maintained databases, application files, AOS, client configuration and access permissions. Providing user access according to the requirement, database maintenance plan, monitoring and performance tuning.
• Installed, configured and administrated Oracle 9i on Windows environment. Performance monitoring and tuning. Performed Oracle user authentication, backup and recovery plan, Oracle maintenance tasks, Tuning Queries, Index reorganization/rebuild indexes, blocking and deadlocks issue and User access issues.
• Rebuilt the indexes at regular intervals for better performance
• Designed and implemented comprehensive backup plan and disaster recovery strategies Implemented and Scheduled Replication process.
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Designed, tested and implemented of DTS packages. Developed SQL Procedure, Views and Triggers.
• Successfully Designed, Implemented, Supported and Administrated Windows 2003/2000 Active Directory Domain, Domain Controllers, Global Catalog Server, Sites, Organizational Units, File and Print Services, Groups Policies Objects, Auditing Policy and Restriction. Created trusts in multiple domain and forests by one way trust or two way trusts.
• Automated SQL Server error log notification process. Used DBCC.
• Designed and tested Backups and Disaster Recovery strategies and applied in Production environment.

Environment: MS SQL Server 2000, MS Access 2000, Windows 2000/2003, ASP.Net, C .Net, VB, XML, XSL, XML Web services, JavaScript, CSS, IIS 6.0 and Crystal Reports.