OBJECTIVE:

To be associated with a growing and innovative organization that will allow me to put my experience and skills to best use. I wish to join a team where I can be of significant contribution and be challenged to personally grow and became a better professional.

SUMMARY:

• 8+ years over all IT experience
• Extensive kn owle dge of Relational Database M ana gement Sy stems.
• Good kno wle dge of s y stem tables and stored pr oc edures .
• Experience in T - SQL writing views, stored procedures and triggers
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Experience in Disaster Recovery Planning and Security Management operations.
• Having hands on experience in DR processes including Log shipping, replication and Database Mirroring.
• Experience in SQL server integration services (SSIS)
• Experience in creating packages and scheduling job
• Experience in upgrading and migrating from MSSQL server 2005 to MS SQL server 2008 R2 to MS SQL Server2012 and MS SQL 2014
• Ability to adapt to changing environments
• Excellent ability to work with team or start alone
• Research new topics, fast, and continuous learner.
• Excellent analytical, interpersonal, problem-solving and communication skills.
• Experience covers all aspects and levels of database Administration in Development, Test and Production environments.
• Adaptable to the agile development methodology/ Scrum.

TECHNICAL SKILLS:

Programming: Mat-lab, C, C++, T-SQL

Relational Database: SQL Server

Software: Microsoft Office Suite; Word, Excel, Outlook.

Operating Systems: Windows 2012, windows 8 professional, windows 7 professional, windows XP, windows Server 2008 and windows Server 2003.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Application SQL Server DBA

Responsibilities:

• Installation, configuration, monitoring SQL Servers(2008R2, 2012, 2014) and databases in development, test, Configuration, production and DR environments
• Installing and configuring SSRS for SharePoint servers and Monitoring servers
• Creating and modifying various databases and database objects (Tables, views, stored procedures…)
• Application and Infrastructure servers and databases maintenance.
• Cre ated logi ns, groups, users, roles, databa se de vices, data ba s e s, mirrorin g device s, che cki ng for databa se con s i s ten c y, monitoring error lo gs, databa se sp ace all ocation s, transactio n lo g spa c e all ocations
• Supporting Costpoint, T&E, STaR, SMART, ODS, ERA, Agilex, AppGRC databases
• Agilex data migration both in Testing and production
• Leading Daily DBA meeting
• Daily and weekly database health check, SQL Servers configuration check and security check.
• Implementing SRs assigned to Data architecture team (database refreshes, T-SQL script writing and reviewing, SQL Server access request…)
• Coordinating server resource management with server, environment management and other teams
• Capacity planning and documentation
• Costpoint upgrade from 7.0 to 7.1.1 in DEV, TEST, STAGE and PROD environment
• High Availability- Log shipping(for Costpoint and T&E databases), Database mirroring( Lync databases), Replication and Always On
• Websense database migration and upgrade from SQL2008R2 to SQL2012
• SARBOX upgrade from v3.15 to v4.5 in TEST environment
• Skype Re-Architecture
• SSIS and SSRS environment preparation, installation, configuration and scripting
• Monitoring Alerts and find a solution or notifying the owners of the applications.
• SQL Sentry performance monitoring
• Assisting, supporting and on boarding new team members
• Monitoring and coaching Junior DBA’s
• Assign tickets to team members according to SR priority level
• 24/7 support

Environment: -Windows 8R2, windows 2012, MSSQL2005, MSSQL2008R2, MSSQL2012, MSSQL2014, SQL Sentry, Costpoint 7.0, Costpoint 7.1.1, Cognos, Microsoft visual studio 2008, 2010, SQL data compare Red Get, SCOM, FIM, TFS

Confidential

Sr. SQL Server DBA

Responsibilities:

• Installed, configured, monitored and maintained databases in the production, development, and quality assurance environments.
• Responsible for Windows Server (2008 R2) configuration and management, specifically as it relates to MS SQL Server installations and mission critical systems.
• Created, Administered, maintained, and monitored multiple Production SQL Server 2008/2008R2 Databases across different servers which included high availability solutions.
• Developed and implemented properly the backup and disaster recovery procedures.
• Log shipping, Mirroring and Replication
• Performed, created, and validated manual data imports and exports as required.
• Created, modified, and maintained SQL Server SSIS packages and stored procedures.
• Created, performed and tested backup and retention plan.

Environment: Windows 7, MS SQL Server 2008 R2, Mic r osoft.NET, Idera, RedGet, Microsoft Visual studio 2008

Confidential

Software Engineer - SQL DBA

Responsibilities:

• Monitored and configured of dedicated databases and servers
• Supported for end users connected to servers in various departments with regard to connection and data access issues
• 24/7 on call support
• Installed and Configured SQL Server in multi user production environments.
• Installed and Configured Operating System
• Migrated databases from earlier versions of SQL Server to SQL Server 2008 and 2008R2.
• Closely work with business analyst to deploy databases and manage availability.
• Performance tuning & optimization of servers
• Develo ped s tored proce dures, trigg ers, v ie w s a nd Added/M odified table s for da ta l oad, trans forma ti on and ex tra ction.
• Monitored Jo bs to ma ke sure all sch ed uled job s ru n su ccessfully every night.
• Selected and entered codes of utility program to monitor data base performance, such as distribution of records and amount of available memory.
• Prepared the project management and technical documentation.

Environment: Windows XP, MS SQL Server 2008, Mic r osoft.NET,, Microsoft Visual studio 2008

Confidential

Database administrator

Responsibilities:

• Database Administration, Database Programming.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Cre ated logi ns, groups, users, roles, databa se de vices, data ba s e s, mirrorin g device s, che cki ng for databa se con s i s ten c y, fixing DBCC e rro rs, monitoring error lo gs, databa se sp ace all ocation s, transactio n lo g spa c e all ocations, fine tu ning SQL pe rforman c e.
• Analyzed va ri ous a s p ect s of Stored Pro c ed ure s an d perfo rmed tu ning a s need ed to increa se prod uctivity and reu s a bility of code.
• Used T-S QL to cre ate que ri es an d stored procedu re s to prod uce re ports fo r end -use rs.
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Participated in full SDLC software component developments
• Troubleshot and resolved issues (performance, database integrity, security issues etc.)

Environment: MS SQL Serve r 20 05, SQL Query Analyze, SQL Profiler