SUMMARY:

• To be an Asset to the organization & strive for excellence in the area of work undertaken with honesty, commitment and dedication to achieve a challenging position where my skills & knowledge can be shared enriched and exhibited .
• My presentation was awarded as one of the best presentation session in the conference.
• The presentation was on the working of the Helios (Product of Allscripts) with the database SQL Server.
• More than 9 years of experience in Database Administration and Data Warehousing and Business Intelligence concepts.
• Designing and implementing database architecture.
• Working experience on SQL 2000/2005/2008/2008 R2/2012/2014
• Attended trainings and working knowledge on Mongo DB and have good exposure on Mongo DB architecture.
• Setting up authentication and encryption on Mongo database.
• Working in coordination with infra IT teams to troubleshoot issues, or to perform builds, deployments.
• Performing pre - production refreshes using both native MSSQL and EMC Networker\Data Domain technologies.
• Ability to work in a global team, interacting/coordinating with colleagues across the world to ensure highest levels of service.
• Knowledge on RDBMS concepts and database architecture for SQL and Oracle
• Working on MS SQL Server 2012, 2014, 2016 and high availability features of SQL 2012, creating and configuring AG’s.
• Certified SQL DBA with more than 9 years of SQL DBA experience. Has a solid knowledge of SQL database architecture, databases design/modelling, SQL and PL/SQL, and implementation.
• Provide SQL Database Administration support and troubleshooting, including install SQL Server software, patches and upgrades; manage and monitor Tablespaces and Tablespaces quotas.
• SQL server maintenance using PowerShell scripting.
• Worked on SQL Development, ability to write and troubleshoot SQL Code and design (stored proc, functions, tables, views, triggers, indexes, constraints)
• Database queries tuning and handling performance issues
• Fine tune the database queries using the Database Tuning Advisor
• Involved in SQL Query tuning and provided tuning recommendations to ERP jobs, time/CPU consuming queries
• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
• Maintenance and monitoring of database systems for optimal performance and availability of databases Performed.
• Responsible for tuning data, building and maintaining indexes and queries.
• Worked on various High Availability features like Log Shipping, Database Mirroring, Replication and Clustering.
• Performing database maintenance activities like backup, recovery and data migrations.
• Monitor SQL server and database performance and proactively address potential performance issues
• Troubleshooting production databases (MS-SQL 2000, 2005 and 2008 and 2012) issues which appear during running of critical updates, which feeds real time updates from different sources in SQL Databases.
• Troubleshoot networks, systems and applications to resolve all database issues, assist developers, network administration, and applications support staff in diagnosing and resolving database related application problems.
• Good Knowledge of Data Warehousing Concepts and experience in Analysis, Design and Development of Data Warehousing (Informatica), Oracle (SQL, PL/SQL), SQL Server in industry verticals like Banking, Healthcare, and Retail.
• Design support structure for database infrastructure, including systems architecture, monitoring, documentation, policies and procedures, backup and disaster recovery, best practices and support automation.
• Following the ITIL and have a good knowledge of ITIL process.

AREA OF EXPOSURE:

• Physical database designing & creation. Devising strategies for backups, recovery & fine-tuning.
• Attended trainings and working knowledge on Mongo DB and have good exposure on Mongo DB architecture.
• Setting up authentication and encryption on Mongo database.
• Working in coordination with infra IT teams to troubleshoot issues, or to perform builds, deployments.
• Performing pre-production refreshes using both native MSSQL and EMC Networker\Data Domain technologies.
• Ability to work in a global team, interacting/coordinating with colleagues across the world to ensure highest levels of service.
• Managing issues for database security and implementing strategies accordingly.
• Providing technical support / input to application development teams.
• Maintenance and monitoring of database systems for optimal performance and availability of databases Performed.
• Monitoring replication and make correction actions in case of problems.
• Monitor jobs execution, and make correction actions when necessary.
• Effectively managing User account & Disk Quota.
• Experience in Transformations, Mappings, Targets, Workflows, Worklets, Sessions.
• Responsible for analyzing, designing and developing ETL strategies and processes, writing ETL specifications.
• Developed standard and re-usable mappings and mapplets using various transformations.
• Extracted Data from flat files and various relational databases to Oracle Data Warehouse Database.
• Created the unit test cases for mappings developed and verified the data.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup, update strategy, etc.
• Addressing and resolving performance bottlenecks and ensuring maximum database/network uptime.
• Suggesting improvements in the operations and processes to make the system foolproof.
• Proficiently handling all the escalations, and troubleshooting 2K/2k3 server problems.
• Imparting training to end-users in the post-implementation phase.
• Providing training to the team members on solution components.
• Training and mentoring all employees towards effective use & protection of company’s assets.

TECHNICAL SKILLS:

Operating Systems: Win XP, Windows 7, Windows Server 2008, Windows 2012.

Databases: Oracle 9i, 10g, MS SQL Server / 2008 R2 / 2012/2014, MongoDB

ETL Tools: Informatica power Centre 8.5, SSIS, SSAS

Reporting Tools: SSRS & Cognos 8, Power BI

Virtual Tools: VMware Workstation for Windows, Hyper-V

Windows Clustering: Windows Server Failover Clustering

Monitoring Tools: Idera Diagnostic Manager, SentryOne, SCOM, Nagios

Database Backup Tools: EMC Networker, Symantec Netbackup, BMC Backtrack, Litespeed

ORGANIZATIONAL EXPERIENCE:

Confidential

Specialist Database Administrator

Responsibilities:

• Working on production database servers and maintain uptime for 99.95 %
• Configuring and implementing backup strategies and restoration policies for production databases servers
• Proficiency in performance tuning, backup and recovery, and schema data modelling
• Attended trainings and working knowledge on Mongo DB and have good exposure on Mongo DB architecture.
• Good experience working with indexing and stored procedures and checking indexes performances and rebuilding new indexes if required.
• Setting up authentication and encryption on Mongo database.
• Working in coordination with infra IT teams to troubleshoot issues, or to perform builds, deployments.
• Performing pre-production refreshes using both native MSSQL and EMC Networker\Data Domain technologies.
• Ability to work in a global team, interacting/coordinating with colleagues across the world to ensure highest levels of service.
• Experience working with BI/ETL tool(s) desirable: BO, Cognos, SSRS, SSAS, Informatica Power Center
• Managing and implementing High Availability solution for SQL 2012 and 2014
• Creating Availability groups and 4 nodes secondary replica.
• Configuring SQL Replication and troubleshooting SQL server replication latency issues
• Configuring SQL Server 4 node clustering and managing and upgrading SQL server cluster servers
• Responsible for day to day management of numerous MS SQL Server databases on Windows Servers in growing and dynamic environments.
• Responsible for tuning data, indexes, and queries.
• Maintenance and monitoring of database systems for optimal performance and availability of databases.
• Troubleshoot networks, systems and applications to resolve all database issues, assist developers, network administration, and applications support staff in diagnosing and resolving database-related application problems.
• Monitor database jobs execution, and make correction actions when necessary.
• Working in the technical team, supporting more than 50 servers in different locations and playing role as a Sr. SQL DBA and System Engineer.
• Defining standards for automating installations, monitoring and working on change control.
• Design and develop database architecture for information systems projects.
• Mapping out the conceptual design for planned databases.
• Working on SQL Server replication, mirroring, log shipping, maintenance plans and DR recovery strategies.
• Working on SQL Server database backup and recovery strategies.

Confidential

SQL DBA (Sr. Technical Consultant)

Responsibilities:

• Managing Production database servers and making sure 99.5 % uptime
• Configuring backup and restoration strategies for production and Test instances
• Attended trainings and working knowledge on Mongo DB and have good exposure on Mongo DB architecture.
• Applying SP and CU’s on the database servers, upgrading the databases
• Configuring the SQL Server Replication for SQL 2008 servers and troubleshooting replication latency issues
• Configured 4 node SQL cluster and 4 nodes secondary replica
• Working in the technical team, supporting more than 100 servers in different locations and playing role as a SQL DBA and System Engineer. Supporting databases used by live and back office production. This included on-call production support and shift work to support to all clients.
• Troubleshooting production database (MS-SQL 2000, 2005, 2008, 2012 and 2014) issues which appears during running of critical updates, which feeds real time updates from different sources into SQL Databases.
• Understanding of Business rules and experience working on T-SQL, Procedure, and Triggers to generate reports or queries from database
• Troubleshoot networks, systems and applications to resolve all database issues, assist developers, network administration, and applications support staff in diagnosing and resolving database-related application problems.
• Monitor jobs execution, and make correction actions when necessary.
• Incident response and investigation.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Responsible for tuning data, indexes, and queries.
• Good knowledge of High Availability-Log Shipping and Clustering.
• Database Backup, Recovery and Migrations.
• Maintenance and monitoring of database systems for optimal performance and availability of databases.
• Troubleshoot networks, systems and applications to resolve all database issues, assist developers, network administration, and applications support staff in diagnosing and resolving database-related application problems.
• Monitor jobs execution, and make correction actions when necessary.
• Incident response and investigation.
• Monitor SQL server and database performance and proactively address potential performance issues.

Confidential

SQL DBA (Sr. Technical Consultant)

Responsibilities:

• Database High Availability implementation and setting up DR strategies
• Configuring high availability groups and listeners for AG secondary replicas
• Log shipping configuration and troubleshooting log restoration issues during log shipping
• Troubleshooting production database (MS-SQL 2000, 2005, 2008 and 2012) issues which appears during running of critical updates, which feeds real time updates from different sources into SQL Databases.
• Understanding of Business rules and experience working on T-SQL, Procedure, and Triggers to generate reports or queries from database
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Responsible for tuning data, indexes, and queries.
• Good knowledge of High Availability-Log Shipping and Clustering.
• Database Backup, Recovery and Migrations.
• Maintenance and monitoring of database systems for optimal performance and availability of databases.
• Troubleshoot networks, systems and applications to resolve all database issues, assist developers, network administration, and applications support staff in diagnosing and resolving database-related application problems.
• Monitor jobs execution, and make correction actions when necessary.
• Incident response and investigation.
• Monitor SQL server and database performance and proactively address potential performance issues.

Confidential

SQL BDA (Technical Consultant)

Responsibilities:

• Working in the technical team, supporting more than 100 servers in different locations and playing role as a SQL DBA and System Engineer. Supporting databases used by live and back office production. This included on-call production support and shift work to support to all clients.
• Troubleshooting production database (MS-SQL 2000, 2005, 2008 and 2012) issues which appears during running of critical updates, which feeds real time updates from different sources into SQL Databases.
• Understanding of Business rules and experience working on T-SQL, Procedure, and Triggers to generate reports or queries from database
• Responsible for tuning data, indexes, and queries.
• Good knowledge of High Availability-Log Shipping and Clustering.
• Database Backup, Recovery and Migrations.
• Maintenance and monitoring of database systems for optimal performance and availability of databases.
• Troubleshoot networks, systems and applications to resolve all database issues, assist developers, network administration, and applications support staff in diagnosing and resolving database-related application problems.
• Monitor jobs execution, and make correction actions when necessary.
• Incident response and investigation.

Confidential

Associate SQL DBA

Responsibilities:

• Responsibilities as an SQL database administrator include configuration, installation and administration of the oracle database systems and tools.
• Develop, implement and maintain the methodology and procedure standards for the effectiveness in the access, backups and recoveries.
• Work closely with the business areas to understand the requirements and to write complex SQL queries.
• My work is to keep an eye on every small changes done in database during development
• Database environment creation, up gradation, and other project-orientated tasks
• Troubleshooting production database (MS-SQL 2000) issues which appears during running of critical updates, which feeds real time updates from different sources into SQL and Oracle Databases.
• Understanding of Business rules and having hands on T-SQL, Procedure, and Triggers to generate reports or queries from database
• Responsible for tuning data, indexes, and queries.
• Monitoring Performance of Various Servers and Applications.
• Implementation of various scripts and procedures to ensure that the system would meet production standards (monitoring, backups etc)
• Co-ordinate with team to resolve various issues faced during release of new version of applications using my application support Skills and get it resolved within given SLA.
• Designed and developed Informatica Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.