SUMMARY:

• Able to work with Confidential
• Demonstrated problem analysis and resolution skills
• Experience working with application vendors
• Ability to work independently
• Strong communication skills
• Flexibility in work schedule
• Analytical and problem solving skills
• Organizational and time management skills
• Good computer skills
• Ability to resolve hardware/software problems
• Self - starter; able to manage multiple tasks efficiently for on-time delivery
• Self-motivated; proactive; a team player; well spoken
• Strong oral and written communication skills, including presentation skills and experience communicating with technical and non-technical audiences
• Strong interpersonal skills to interact with clients from a business development and technical expert

PROFESSIONAL EXPERIENCES:

SQL Server Database Administrator

Confidential

Responsibilities:

• Deep understanding and working experience of SQL Server (SQL 2000, SQL 2005, SQL 2008, and SQL 2008 R2, SQL 2012, SQL 2014), MS Access, and MySQL includes installation, configuration, and maintenance of standalone and Clustered Servers Active/Passive Cluster Design.
• Experience of Install, upgrade and administer SQL Server database engine, Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS).
• Expert of database Backups and Restoration
• Strong working experience in installing, upgrading, and maintaining Web servers (IIS) and Operating Systems: Microsoft Windows Server Family (2000,2003, 2008)
• Applied Service Pack (SP) and hot fixes for Databases, Operating Systems
• Strong working experience in creating and supporting database administration scripts; scheduling jobs
• Experience using Configuration Tools such as SQL Server Configuration Manager and SQL Server Surface Area Configuration
• Database Migration: Migrated Oracle 10gR2, MySQL, MS Access 2003/2000/97 databases into MS SQL Server 2008 R2
• Imported/Exported Excel, Flat file, CSV file to SQL Server Databases
• Good experience in writing and debugging SQL Server stored procedures/triggers and documenting issues/resolutions of SQL Server Applications
• Administer, run, and maintain clients Windows server infrastructure in production
• Develop and maintain installation and configuration procedures; contribute to and maintain system standards, policies, and procedures
• Maintains system performance by performing system monitoring and analysis, performance tuning, troubleshooting system hardware, software, and operating system issues
• Ensure correct installation, configuration, use, and maintenance of our windows server infrastructure
• Install new/rebuild existing servers and configuration hardware, peripherals, services, settings, directories, storage, etc. in accordance with standard and project/operational requirements.
• Research and recommend automated approaches for system administration tasks where possible.
• Create and Maintain SOP’s and train staff members
• Exceed expected quality of service on maintenance & deployment of upgrades, enhancements and modifications to systems
• Provide daily administration of workstations and servers in a fully virtualized environment.
• Demonstrated ability to work with application owners to formulate, troubleshoot and document application installations
• Strong working knowledge of Windows AD and Server OS technologies.
• Knowledge of HA computing and networking. (eg. Microsoft Clustering, load balancing, TCP/IP, DNS)
• Understanding of application & OS security, including virus scan management and patching

Senior SQL Server Database Administrator

Confidential

Responsibilities:

• Installed, Configured, and Administered SQL Server 2005 & 2008 in development, test, and production environment
• Installed, Configured and Managed Database Mirroring, Replication and Log Shipping. Installed, Configured and Maintained Fail-Over Cluster Servers in SQL Server 2012
• Wrote SQL, T-SQL, Stored-Procedures and triggers. Assisted SQL developers to optimize SQL queries, Stored Procedures and Triggers
• Performed database monitoring and Performance tuning. Monitor Servers activity, and worked with clients to solve different problems. Performed index and statistics management. Managed SQL Server Error Logs, space usage, growth pattern. Used DBCC and ALTER C statements to check and manage database consistency, index fragmentation/rebuilding, statistics. Managed BLOCK and LOCK
• Created Backup jobs for different types of backup like FULL, Differential and Transaction Log. Created Jobs for database maintenance Index fragmentation, rebuild, database statistics. Created BAT programs to move backup and other files to backup servers
• Worked on different Data Modeling projects using Toad Data Modeler on designing Logical & Physical Database. Used Backward & Forward Engineering to create Logical and Physical database
• Created and managed Index (Cluster/Non-Cluster), Constraints
• Created and Managed users, roles, security at object level, data encryption
• Export & Import data from/to Oracle, MySQL, and Access Database including flat files like text, excel, and CSV files to SQL Server 2005/2008
• Migrated MS Access databases into MS SQL Server. Migrated Oracle 10g, MySQL database into MS SQL Server 2008. Imported data from Oracle, Excel, Flat file, CSV file to SQL Server Database,
• Work experience and strong knowledge in disaster recovery. Rebuild databases using backups
• Installed, Configured, and administered SQL Server Reporting Services (SSRS). Developed Reports using SSRS. Developed Ad-hoc Reports using Report Builder 3.0, 2.0. Deployed Reports. Managed security for reports

SQL Server Database Administrator

Confidential

Responsibilities:

• Maintained mission critical production database as well as production applications including Emergency off-hour support
• Installed and configured SQL Server 2000, and 2005 on Windows Server 2000 and 2003 as standalone and Clustered Servers
• Automating Database tasks (Created jobs, alerts, and schedules for database maintenance tasks)
• Wrote SQL/T-SQL codes, stored Procedures, Triggers and Functions
• Helped database developers to tune up SQL/T-SQL Queries
• Applied Service Packs, and hot fixes
• Performed database backups, restored database from backup
• Configured and maintained transactional and merge replication
• Access and security management like creating Logins with appropriate roles. creating users and groups and granting and revoking privileges for data security
• Migrated Oracle, MySQL, MS Access 2000/97 databases into MS SQL Server 2000and2005
• Configured and Maintained Replicated database using LogShipping and Replication in SQL Server 2000 and 2005 for high availability
• Using SQL Server profiler, Windows performance monitor and Database engine tuning advisor to analyze and fine tuning of long running queries and stored procedures and slow running servers
• Created documentation for installation, monitoring procedures, security policies, configuration changes, migration procedures, and best practices
• Installed, configured and maintained SQL Server 2000/2005 Reporting Service. Managed reports and helped developers in designing and developing reports