SUMMARY:

• Microsoft Certified Dynamics AX System Administrator 2012R2/R3 & 2009, AX Performance Tuning Specialist and Microsoft Certified Solution Expert (Data Platform) with over 18 years IT Experience and around 10 years as AX System Administrator including 14 years as Database Administrator with demonstrated expertise in installation, configuration, administration and Production Servers maintenance of Dynamics AX 2012 R2/2009/4.0 and MS SQL Server 2014/2012/2008 R.
• Managing users in AX 2012 including assigning roles to users, assigning profile to users and importing users from the active directory.
• Working with Licensing in AX 2012 including adding a new license key, importing a license file and providing user license count to management team using standard AX - SSRS report.
• Model Management including installing/uninstalling an AX model, managing conflicts and exporting/importing a model store.
• Setting up and managing the Application Object Server (AOS) including creating a server cluster, configuring an AOS instance as a batch server and draining users.
• Setting up and managing E-mails and batch processing.
• Maintain the integrity, security and performance of all dynamics AX/Database servers and systems through proactive monitoring and quick problem resolution.
• Implemented SQL always on with Primary and two secondary servers for Dynamics AX 2012 R2 & R3 environments.
• Implemented SSRS scale out deployment for dynamics AX 2012 R3 environment on SQL always on.
• Involved in Backup Committee meetings to ensure proper backups and schedules are taking place and recommend changes to backup schedules and enhancements to the overall backup process
• Conduct assessments to assure that security, and risks are identified and mitigated. Comply with all regulatory initiatives, e.g. Sarbanes-Oxley and audit findings.
• Working closely with the infrastructure team to build hardware sizing requirements
• Promote development objects during build and test activities using xpo’s, models and model Stores.
• Build and/or copy new Dynamics AX environments as needed throughout the project
• Support or execution of data migrations into a Dynamics AX 2012 environment using the Microsoft Data Migration Framework or other technologies.
• Incident Management; processing, troubleshooting and resolving customer requests and problems.
• Identify areas of improvement within application environments to increase stability and reduce administration efforts
• 3rd party application integration(Rfsmart, Vertex, data mason and Accellos WMS/EDI) and support
• Work with users and developers/programmers to correct recurring problems with software
• Provides assistance and guidance to peers with day-to-day operations of Applications and Application Systems
• Establish, coordinate and maintain solution/systems documentation. Work closely with other IT SME’s to ensure content is correct.
• Review and apply needed Microsoft Dynamics AX hotfixes and patches.
• Coordinate and execute the refresh of Dynamics AX Development, Test and Production environments.
• Troubleshoot Dynamics AX technical and environmental issues.
• Work directly with the Development and Functional teams to maintain multiple Dynamics AX application environments.
• Work directly in the AOS and database server for performance monitoring and application tuning.
• Interface with vendors and Microsoft for installation and technical support as needed.
• Provide extended off-hour support when required.

TECHNICAL SKILLS:

Databases: MS SQL Server 2014/2 R2/2005 and Oracle (11g, 10g, 9i and 8i)

Oracle Products: SQL*Plus, PL/SQL, Oracle Enterprise Manager

Tools: OEM, RMAN, Export, Import, Data pump, Tkprof, STATSPACK, AWR, ADDM, TOAD7.6, ERWIN, Grid Control (10g)

Operating System: AIX, Red Hat Linux, Win 2000/2003/2008/2008 R2/2012R2, MS-DOS.

Languages: SQL, PL/SQL,Enterprise Manager (OEM), Oracle, Utilities (Import / Export, SQL*Loader, 10g Data Pump)

ERP system: Dynamics AX 2012 R2/R3/2009/V4, SharePoint (MOSS & WSS), Oracle Hyperion and Siebel

WORK EXPERIENCE:

Confidential, Seattle, Washington

Sr. Dynamics AX System Administrator/Database Admin

Responsibilities:

• I am responsible for the Dynamics AX 2012 R2 CU7 environment including installation, configuration, troubleshooting, support and administration.
• Involved in dynamics AX and database server capacity planning for GACO ERP system implementation.
• Installed and configured the RD Web Access Web site by using the Remote Desktop Web Access Configuration.
• Implemented AX AOS load balancing, administration and performance optimization.
• Implemented Microsoft Reporting Services and Analysis services extension.
• Utilize AX model Store, AX Model Files and XPO to migrate code
• Build and/or copy new Dynamics AX environments as needed throughout the project
• Implemented database maintenance plan for Dynamics AX
• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Set up and schedule jobs that perform backups and database structure checks
• Performed all aspect of AX system administration and database administration, including backup, recovery, and replication for SQL server 2014.
• Analyze some of the long running slow queries & tune the same to optimize application and system performance.
• Scheduled jobs and alerts using SQL Server Agent.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• 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 2014, T-SQL, Windows Server 2012 R2, Dynamics AX 2012 R3 and Share Point 2013.

Confidential, York, PA

Sr. Dynamics AX System Administrator

Responsibilities:

• I was responsible for the Dynamics AX 2012 R2/2009/V4 environment including installation, configuration, troubleshooting, support and administration.
• Involved in dynamics AX and database server capacity planning for Confidential ERP system implementation.
• Implemented AX AOS load balancing, administration and performance optimization.
• Implemented Microsoft Reporting Services and Analysis services extension.
• Responsible for ensuring the reliable performance of ERP systems
• Utilize AX model Store, AX Model Files and XPO to migrate code
• Promote development objects during build and test activities using xpo’s, models and model Stores.
• Build and/or copy new Dynamics AX environments as needed throughout the project
• Manage AX user and security Roles
• 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.
• Designed and developed SQL Server Integration Services (SSIS) for data migration.
• Set up and schedule jobs that perform backups and database structure checks
• Monitored MS SQL servers for errors and performance degradation.
• Performed all aspect of database administration, including backup, recovery, and replication for SQL server 2012/2008 R2/2005.
• Maintained the database consistency with DMV’s/DMF’s at regular intervals
• Analyze some of the long running slow queries & tune the same to optimize application and system performance.
• Scheduled jobs and alerts using SQL Server Agent.
• Used system stored procedures and DBCC commands.
• Involved in database log backups & restoration, backup strategies, scheduling.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Backing up users & system databases and restoring them when necessary.
• 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 2012/2008 R2/2005, T-SQL, Win 2003/Windows Server 2008 R2, VB, ASP, Dynamics AX, share Point and Siebel Analytics.

Confidential, Scottsdale, AZ

Sr. Database Consultant

Responsibilities:

• Worked as a Database Administrator and I was responsible for requirement analysis, design, document, development, enhancement and support of MS SQL Server and Oracle Databases.
• I was responsible for Database Infrastructure designing, best practice recommendation, Implementation of Microsoft SQL 2005 clusters, administration and troubleshooting for various projects and applications.
• Worked on Oracle 10g servers running on Red Hat Enterprise and performed administration. Backing and recovery of databases. RMAN utility, SQL Tuning advisor, Performance monitoring and tuning.
• Installed/Upgraded/Migrated SQL Server 2005 on 64 & 32 bit systems both clustered (Single and multi-node clusters) as well as standalone Servers.
• Involved in the Capacity Planning for databases based on the future business growth requirements and estimated the space requirement before a table or index is created.
• Involved in migrating data from Oracle to SQL Server and SQL Server through import/export and BCP utility.
• Planned and worked on setting up Table Partitioning for faster maintenance such as rebuild and update statistics.
• Assisted the application development team with tuning and optimization of long running SQL and PL/SQL queries for better performance.
• Implemented, configured and Monitoring, Alert and Problem Remediation Scripts via both the OEM and Oracle Management Server. Homegrown scripts using Perl and Windows/VB scripting.
• Worked with Oracle support to open, manage and resolve service issues with the Oracle products support via Oracle SR.
• Successfully Designed, Implemented, and Administering Microsoft Windows Server 2003 and Microsoft SQL Server 2005 Cluster.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies. Building Oracle and SQL Servers best practices and security Standards.
• Monitor database files, data block corruption, segment fragmentation.
• Oracle and SQL Server 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.
• Analyzed the strange behavior of the server and provided fixes for the bugs investigated.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Worked flexibly at late hours with the application team on making any changes to the Production Servers.
• Helped the application developers on writing T-SQL queries.

Confidential, Mount Laurel, NJ

Oracle& SQL serverDatabase Administrator

Responsibilities:

• Installed, configured and maintained Oracle Databases 9i on Linux and Windows platform.
• Installed, configured and supported oracle 9i physical standby database.
• Implementation of RMAN backup and recovery strategy.
• Managing, troubleshooting and resolving oracle database and applications issues.
• Performing monitoring and performance tuning.
• Performed database and application tuning through the use of AWR and ADDM through OEM.
• Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.
• Tuning SGA, I/O Tuning, Identifying contention, waits and tuning.
• Usage of Partitions to improve the query performance and manageability.
• Implemented backup/recover strategies using RMAN, COLD Backups, Export/Import utilities, and shell scripts.
• Flash back Recovery Setup.
• Provided database-related design recommendations to application developers as required.
• Maintain standby databases using replication utility named Data Guard.
• Working alongside programmers and contributing to the development process; Enabling and analyzing trace files.
• Defining and Setting backup and recovery procedures.
• Tuning the database using Statspack and custom scripts.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Experienced in Tuning SQL statements using Explain Plan, SQL Trace, TKPROF and STATSPACK
• Writing Shell Scripts for managing day-to-day activities and automation of backup.
• Optimal Space utilization in table space by avoiding fragmentation.
• Installation of Oracle RDBMS server software and version upgrades.
• Recovery of Database (Recovering tables dropped accidentally, Recovering data files).
• Installation and configuration of Oracle Client software and Tools.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Maintaining the database consistency with DBCC at regular intervals
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Designed & implemented comprehensive Backup plan and disaster recovery strategies.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance

Confidential

Oracle/ SQL server Database Administrator

Responsibilities:

• Worked on Oracle 8i 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.
• Provide application deployment and code migration support to the project/team lead on deploying new Application, DB objects and data changes through the various stages of the development life cycle.
• Apply security patches to Oracle and SQL Servers; maintain regularly hot and cold backup and recovery, policies/procedures/scenarios for the databases.
• Involved in Architectural design for the databases and database tablesandcapacity planning.
• 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.
• Monitoring and optimizing the performance of the databases.
• Designed and implemented hot backups using a combination of incremental, differential and full backups using RMAN.
• Creation, maintenance, and administration of databases under Windows environments.
• Cloning of production database to the test environment.
• Creating primary storage structure and the objects.
• Running SQL Tuning scripts for gathering information on database performance like sorts, gets, misses, cache hits, disk I/O activity, disk reads etc.
• Database performance and tuning issues.
• Tuning of I/O, which includes separating of data files and redo log files on different locations, striping.

Confidential

Oracle/ SQL server Database Administrator

Responsibilities:

• Installed, configured and administered and troubleshooting Oracle 8i 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 Enterprise Manager, Export/Import Utility, Data Bump utility. Oracle. AWR, Statspack, ADDM, Oracle Universal Installer, Oracle Patch testing and applying in production databases.
• Implemented, configured and Monitoring, Alert and Problem Remediation Scripts via both the OEM Oracle 10g Enterprise GRID Control Manager/Oracle Management Server.
• Provide application deployment and code migration support to the project/team lead on deploying new Application, DB objects and data changes through the various stages of the development life cycle.
• Apply security patches to Oracle and SQL Servers; maintain regularly hot and cold backup and recovery, policies/procedures/scenarios for the databases.
• 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.
• Designed and implemented Backup plan and disaster recovery strategies
• Involved in trouble shooting and fine-tuning of databases for its performance and high availability.
• 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 Oracle and SQL servers and troubleshoot any failures or alerts, open trouble tickets if necessary to work with technicians from other departments.
• 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.
• Analyzed, fine-tuned and optimized MSSQL 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.