SUMMARY

• Has overall 20+ years of rich and diverse experience in IT Industry and 10+ years in United States, worked in different databases, analysis, design, development, implementation, testing, and maintenance of application systems in the Internet/Intranet and Client Server environments.
• Extensive experience in installation, configuration and administration of SQL Server 7/2000/2005/2008/2008 R 2/2012/2014/2016/2017/2019
• Expertise in SQL upgrade and SQL migrations, upgraded & migration more than 100+ SQL Servers.
• Extensive experience in installing, configuration and administration of MS clustering.
• Experienced in T - SQL Programming and performance tuning, optimization
• Extensively involved in 24/7 Production support of the databases and round-the-clock database operations
• SQL DBA activities include but not limited to Installation, configuration, importing/exporting, patch installs, capacity planning, backup and recovery of mission critical databases
• Supported over 1500+ SQL 2008/2008R2/2012/2014 servers and 1000+ databases in clustering environment (A/A, A/P) and databases from 500+ Gig - 1 TB in size
• Technical Lead in charge of migrating over 180 databases from SQL Server 7.0 to SQL Server 2000 and SQL 2000 to SQL 2005
• Created complex DTS Packages for Data Migration and Transformation. Experience in data migration from Oracle/Access/Excel Sheets to SQL Server 2012/2008/2005/2000/7.0
• Implemented a recovery plan to a point in time failure
• Responsible for data security and Integrity with HIPAA requirements
• Implement and maintain database security, replication, SQL Clustering, Stand by server, DTS, SSIS, Log shipping, Database Mirroring, SQL Mail, database mail
• Strong experience in Always ON ( HA )
• A hands-on SQL Server Database Administrator (DBA) and Web Administrator with a proven track record of team leadership and technical skills
• Knowledge in Amazon Redshift
• Sound knowledge and expertise in Red gate, TSM tools
• Responsible for establishing best practices, standards
• Responsible for establishing and enforcing security mechanism
• Very good experience in Installation, configuration and maintenance of Oracle/SQL Server.
• Worked with large Databases sizes ( 15TB+) in SQL server Environment
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Excellent backend and Architecture skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Complex SQL’s, user defined data types and functions.
• Very good T-SQL Programming skills. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands
• Experience in Database backup and disaster recovery procedures.
• Experience in Replication - Snapshot, Merge and Transaction and peer-to-peer.
• Has very good experience in complete ETL cycle including data analysis, database design, data mapping and conversion and data load.
• Extensive experience with Oracle 9i Database, Replication, performance tuning, data warehousing, Materialized Views, backup and recovery, RMAN etc.
• Expertise in Oracle version from 7.x - 10g and MySQL (4.x - 5.1)
• Used AGILE methodology in Software Development process.
• Performed & Developed a best practices related to Security and Privacy
• Worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in SQL Server.
• Experience in SharePoint 2010 has an administrator
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).
• Experience in Microsoft BI Tools
• Had a methodology and Experience in identify and debugging reports.
• Experience in software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Has the ability to work in a fast paced environment, Good team player and can work independently. Helped the database developers on technical issues.
• I have responsibilities in designing document database of architecture. I build data scheme, tables, and procedures. I am a hard worker with compatible attitude.

PROFESSIONAL EXPERIENCE

Confidential, Des Moines, IA

Senior SQL DBA

Responsibilities:

• Responsible for planning, designing, and putting in place strategies for the development, implementation and maintenance of moderate to complex database systems. Includes strategies for monitoring, optimization, clustering, and backups.
• Responsible for the planning and design of MS SQL Server implementation and configuration with emphasis on security and optimization of resources and performance.
• Responsible for the ensuring appropriate documentation is in place for database design and configuration.
• Evaluate various infrastructure requirements and options for cloud based IoT platforms
• Work within IoT segment of IoT and Security Solutions team to define integrated solutions (hardware and software) addressing IoT market connectivity, security, and reliability challenges
• Mentors and help guide the development of less senior database administrators. Helps teach new database administrators key processes that support the TMG database environment.
• Proficient in unit testing of moderate to complex database development and enhancements with the goal of providing a stable production environment while optimized for end-user performance.
• Builds and maintains database systems in such a way that exceeds regulatory requirements.
• Communicate consistently and effectively with internal business partners to understand appropriate business requirements.
• Assist project team members in developing scope documents.
• Provide and help document database and infrastructure strategies that lend to a secure and optimized environment.
• Assist project team members in the development of project scope and estimates.
• Proactively research and learn new database technologies, share that knowledge with other team members and apply those technologies to the TMG database environment.
• Identifies development opportunities and works with manager to establish learning focus and learning plan.
• Manages learning plan and reports on progress during one-on-ones with supervisor.
• Develop working relationships with internal business partners and project team members.
• Acts as a liaison for the Data Services department to other TMG departments.
• Develop knowledge of internal and external partner business.
• Build trust with our partners in our knowledge and delivery of technology.
• Communicate effectively to other project team members and internal business partners as required.
• Actively supports our CO-OP culture and embraces our core values of Work as Partners, Communicate Openly and Honestly, Demonstrate Excellence and Champion Change in all interactions.

Confidential, Atlanta, GA

Senior SQL DBA

Responsibilities:

• Manages physical databases on specific database technologies.
• Managing cluster of SQL servers
• Design and implement back-up, recovery, archiving, and conversion strategies.
• Cloning production data to development/test environments, and application optimization including query optimization.
• Managing and maintains data definitions in all production and non-production databases and replication servers.
• Managing database distribution, security, and access requirements.
• Designs and develops logical and physical layers of databases.
• Audit and document database environment.
• Handling testing, reporting, back-up, and restores.
• Experience in managing delivery of complex solutions involving IoT, M2M, cloud, security, professional services and SaaS
• Experience designing integration and cloud architecture, with a focus on IoT (Internet of Things)
• Experience in managing MongoDB environment from availability, performance and scalability perspectives
• Providing technical assistance and mentoring to staff for developing conceptual and logical database design and the physical database.
• Recommends, installs, and maintains database software.
• Monitors performance and performs database training and assists application developers with train tuning efforts.

Confidential, Des Moines, IA

Senior SQL DBA / Team Lead

Responsibilities:

• Manage day-to-day operations (includes monitoring and maintenance, problem investigation and resolution, backup creation and maintenance, database optimization and tuning, etc.).
• Effectively prioritize and manage concurrent projects, demonstrate initiative and work independently with minimal supervision.
• Drive results and leverage past experiences to improve the environment and related processes.
• Foster a spirit of teamwork, coach and mentor staff and empower employees to take responsibility.
• Stay current on technology and industry standards; work with leadership to develop strategic plans and roadmaps.
• Coordinate with other agency departments to update and integrate processes as necessary.
• Upgraded more than 35+ SQL Servers from SQL 2005, 2008 to SQL 2016
• Migrated successfully 5+ TB of database from SQL 2012 to SQL 2014 and configured Transaction replication as part of DR.
• Worked on Azure hosting for Department of Human Services, Department of Public Health
• Configured TDP and TSM backup solution for SQL and Oracle Databases
• Handled a team of 6 FTE’s and 13 other state agency department DBA’s
• Suggested latest upgrades and technologies for NoSQL databases
• Evaluated system performance and validated NoSQL solutions, Managed and administered all NoSQL database systems

Confidential, West Chester, PA

SQL Tower Manager / MSSQL

Responsibilities:

• My Primary role is to manage team of 13 offshore and 1 onsite DBA’s, provide Techinical and Process level support to team members and Confidential application teams
• Supporting (L3 & L2 level) 1800+ SQL Servers which will have more than 1500+ SQL instances
• Current Confidential application level supports which includes 600+ applications
• Expertise in 2008/2008R 2/2012/ 2014/2016 versions of SQL
• Expertise in implementing DR like Alwasys on High Availability, Replication, Mirroring
• Sound knowledge and expertise in 20+ different common tools whcih is used to monitor the DB performance, OS performance in Confidential
• Review and analyze current client’s technology infrastructure while identifying, proposing IoT strategies, and deploying and supporting critical IoT solutions
• Responsible for the acquisition and management of IoT services at the launch of new solutions
• Assist in the evaluation of new solutions for integration into the IoT Roadmap/Strategy
• Expertise in Remedy, JIRA, Tableau, SQLO3, OEM
• Sound Knowledge/expertise in Change Management, Incident Management, Problem Management - Events, Problem Management - Incidents, Service Request and Capacity Management

Environment: MS SQL Server 2008/2008R2/2012/2014, T-SQL, SSIS, SSRS, MySQL 5.1 & 5.6, Windows 2008R2/2012, Remedy, JIRA, SQLO3, OEM, MonYog, iTRC, OIV, FIXEM, NSG, IPAM, IP CenterConfidential

Senior SQL / MySQL DBA

Responsibilities:

• Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Working with development and systems teams to perform application and database tuning.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Setup and maintenance of appropriate database and application monitoring.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Experience in Logical / Physical Data modeling
• Development of a data strategy and associated polices
• Selection of capabilities and systems to meet business information needs
• Skilled in setting up metadata registry
• Vast experience in Data Dictionaries and Data Warehousing
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.
• Setting up and Monitored transnational replication, Database mirroring on Production and QA servers.
• Responsible to Monitor and troubleshooting Log Shipping. Responsible routine DBA jobs like Backups and Restores.
• Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development life cycle.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS). Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Used Sybase Power Designer/ MS Office Suite to articulate and design UML: Use Cases Diagrams, Activity Diagrams and Sequence Diagrams adopting Agile/Scrum methodology
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005/2008/2012 .
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL. Used Policy Based Administration feature (SQL Server 2008).
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Worked With 'upsert' commands to programmatically INSERT data if it does not exist or UPDATE the data if it does all in 1 set of logic (SQL Server 2008).
• Checking Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Worked on ESRI files, like import and manipulate geodata for marketing analysis
• Prepared Documentation for the Disaster Recovery plan
• Install, configure, update and troubleshoot a HUGE MongoDB environment
• Configure and monitor numerous MongoDB/NoSQL instances
• Study the database needs of our applications and optimize them using MongoDB and NoSQL
• Worked on GIS (Geographic Information System ) to provide map, model, query and analyze large quantities of data within a single DB
• Having knowledge / Expertise in IT Service Management like strategic approach to designing, managing - ITSM ( IT Service Management)
• Reverse engineered the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for new enhancements of reports
• Extensive DB2 Connect, WebSphere Federation Server experience with activities involving configuration and maintenance of wrappers, server definitions, user mappings and nicknames
• Developed plenty of reports using SSRS and Crystal reports.
• Release manage the data model in all environment ( Dev/QA/UAT/Perf/Prod)
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Used Extensively FileMaker Pro to integrate a database engine with Microsoft Dynamics CRM 2013, also created custom applications based on organization requirement. Did Integration with active directory so that you can determine what rights a user has based on their Active Directory credentials used to login to FileMaker.
• Sound Knowledge and experience in SharePoint 2010. Administration functions including deploying code solutions (.wsp), PowerShell scripts, server optimization, server management, term store maintenance, taxonomy, content deployment, web and service applications in Central Administration
• Knowledgeable in Open systems platforms with DB2 Universal Database (UDB) for Linux, Unix, and Windows (DB2 for LUW)
• Integrated replicate data into existing system using DB2 Data Replication.
• Responsible for merging two different version of MySQL database.
• Did data migration from MySQL to PostgreSQL.

Environment: MS SQL Server 2005/2008/2012 , T-SQL, SSIS, SSRS, AGILE, Crystal Reports, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, Windows XP/2000 and Windows 2003/2008/2012 Server, PostgreSQL, DB2, SharePoint 2010, Hyper-V, MySQL (4.x, 5.1), SQLYog, Windows Terminal Services Client, VPN, Microsoft Dynamics CRM 2013, CozyRoc