SUMMARY:

• Experienced hands - on professional experience in SQL Server database as a DBA
• Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication, Alwayson
• Experience in troubleshooting and resolving frequent database issues including integrity issues, replication, log shipping, mirroring, connectivity, and security related issues etc
• Experienced in installing and configuring SQL Server, applying patches and fixes
• Strong knowledge in setting up and managing database security by creating new users, roles, profiles, and provide required user privileges in development, test, training and production environments
• Experience monitoring, troubleshooting and performance optimization related issues
• Extensive experience in using DTS, SSIS, BCP to import data from different sources of data into SQL Server Databases
• Knowledge in Configuring SQL Server Agent, create, maintain and monitor jobs
• Knowledge of Power Shell and T-SQL scripting.
• Have excellent analytical, problem solving, communication and interpersonal skills with ability to interact with people at all levels and can work as part of a team or independently
• Devoted and Quick learner with capability to master and implement new technologies
• Excellent presentation and documentation skills
• PL1 programing Language
• Excellent experience on Adabas Natural.

TECHNICAL SKILLS:

Databases:: Microsoft SQL Server 2000/2005/2008/2012, MS Access, BD3

Tools:: SSMS, SSIS, SSRR, on SQL Server

Operating System:: Windows server 2000, windows server 2003, windows server 2008 and Vista/windows 7, Windows /98/2000

Web server:: MS Internet Information Server (IIS)

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

SQL Database Administrator/DBA

Responsibilities:

• Major duties: Installed and Configure SQL Server 2000, and 2005 in test and production environment.
• Migrated databases from SQL Server 2000 to 2005 in test and production environment.
• Migrated MS Access 2003 databases into SQL Server 2000.
• Closely worked with business analyst to collect requirements & make systems available ASAP.
• Rebuild Servers (Restore & Recovered from tape/CD backup) from backup.
• Configured Log Shipping from Production to Standby Server (Running as Reporting Server).
• Configured and Maintained Replications (Transactional).
• Writing T-SQL and/or. PowerShell Scripting and Stored-Procedures.
• Performed Database, SQL, and index tuning.
• Assisted SQL developers to optimize SQL queries and Stored Procedures.
• Grant internal/external developers to development servers, shares.
• Created Backup strategy for production and development environment.
• Database Backup & Restore.
• Scheduled jobs.
• Setup and configure Database mail for notification purposes.
• Developed Database Maintenance Plan.
• Monitor Servers activity, solving problem.
• Monitor and resolve Mantis bug tracker for client issues. Troubleshooting connectivity issues Permissions, etc with custom applications and SQL.
• SQL Server Error Log, space usage.
• Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes.
• Export & Import data from Oracle, MySQL, and Access Database including flat files like text, excel, and CSV files into SQL Server databases..
• Designed Logical & Physical Database
• Involved in creating and modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers.
• Used DBCC to check physical and logical consistency of database and Rebuilding indexes.
• Database Monitoring - Used Clever Path Dashboard to monitor and diagnose different problems.

Environment: MS SQL Server 2008/2005/2000, Windows 2000 Advanced Server, and Windows Server 2003 Enterprise Edition

Jr. SQL Database Administrator/DBA

Responsibilities:

• Major duties: Installed and Configure SQL Server 2000, and 2005 in test and production environment.
• Migrated databases from SQL Server 2000 to 2005 in test and production environment.
• Migrated MS Access 2003 databases into SQL Server 2000.
• Closely worked with business analyst to collect requirements & make systems available ASAP.
• Rebuild Servers (Restore & Recovered from tape/CD backup) from backup.
• Configured Log Shipping from Production to Standby Server (Running as Reporting Server).
• Configured and Maintained Replications (Transactional).
• Writing T-SQL and/or. PowerShell Scripting and Stored-Procedures.
• Created Backup strategy for production and development environment.
• Database Backup & Restore.
• Monitor and resolve Mantis bug tracker for client issues. Troubleshooting connectivity issues Permissions, etc with custom applications and SQL.
• SQL Server Error Log, space usage.
• Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes.
• Designed Logical & Physical Database
• Involved in creating and modifying tables, Index (Cluster/Non-Cluster), Constraints (Unique/Check), Views, Stored Procedures, Triggers..

Environment: MS SQL Server 2005/2000, Windows 2000 Advanced Server, and Windows Server 2003 Enterprise Edition

Sales Data Analyst

Responsibilities:

• Use in-house and PAX-is data and analyze it to track the distribution channels activity and introduce appropriate sales strategy.
• Support the development and analysis of measurable components of data collection activities, apply techniques to data management, quality assurance, and explore best approaches to data analysis and reporting.
• Maintains and monitors records and reports of frequent fliers, travel agencies & travel related agencies & any relevant organizations.
• Analyzes the effectiveness of sales, methods, costs, and results.