SUMMARY:

• Five years of IT experience in help desk technician, SQL Server Database Administration, System Analysis, Testing, Development and Support of MS SQL Server 2016/ 2014/2012/2008 R2/2008/2005 in PRODUCTION and DEVELOPMENT Environments.
• Experience in database administration and development activities such as Installation, Configuration, Database design & development Backup & Recovery, Performance tuning and Query Optimization and Database Security.
• Knowledge of Relational Database Management Systems (RDBMS).
• Knowledge in reviewing TSQL, Stored procedures, Views, Triggers and Functions.
• Expert in implementing High Availability Solutions such as for Replication, Mirroring, Log Shipping, clustering and Always On in MS SQL Server Environments.
• Experience in implementing different types of Replication such as Snapshot and Transactional.
• Skill in database Backup, Recovery and Disaster Recovery procedures. Developed and documented disaster recovery plans and backup and recovery strategies for production environment.
• Excellent communication skills, organizing skills, highly punctual and an excellent listener.

TECHNICAL SKILLS:

Operating systems: Windows Enterprise 2003/2000 Advanced Server, Windows 2000 Server, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Server and UNIX

SQL Tools: SQL management studio, Service area configuration, SQL profiler and SQL server configuration manager.

Languages: T - SQL,

Relational Databases: MS SQL Server 2016/ 2014/2012/2008 /2005 , MS Access.

PROFESSIONAL EXPERIENCE:

Confidential, MI

SQL Server DBA

Responsibilities:

• Installed and configured MS SQL Server 2016/2014 on standalone and clustered environments. 
• Managed MS SQL Server 2016/2014/2012 databases. 
• Experience in migrating contents from MS SQL server 2014/2012/2008 to MS SQL server 2016. 
• Auditing of databases for user's transaction, login and database action and fixing orphan users. 
• Managed users and groups (roles) from Active directory or SQL, provide appropriate server roles, map them to specific databases and grant specific privileges over selected database securable objects to ensure security and integrity. 
• Analyzed and deployed scripts and packages in prod/test environments from different developers based on CR/change request process. 
• Responsible for creating and monitoring database maintenance plans and schedule jobs using SQL Agent/Maintenance plan; Schedule database integrity check, reorganize/rebuild indexes, update statistics, backup/restore and cleanup job history. 
• Extensively used SQL native tools for performance monitoring /analysis and troubleshooting. Performance tuning by analyzing execution plans, creating and maintaining indexes (rebuild/reorganize), Statistics and Client/Server Connectivity. 
• Analyzed Locks, Blocks, Dead Locks, Resource Utilization, handling Isolation Level and Concurrency issues. 
• Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability.
• Supported implementation of Always ON, Availability groups by creating availability databases using the high availability and DR strategies in clustered environment. 
• Experienced with configuring database high availability techniques like Replication, clustering as well as implementing disaster recovery techniques like database mirroring and log shipping. 
• Monitored SQL Server Error Log, Windows Event Logs, Profiler, Query Execution Plan, Index Tuning Advisor, Database Tuning Advisor, System Monitor, troubleshooting performance issues. 
• Experienced in implementing, configuring and maintaining different types of Replication Models like Snapshot and Transactional.

Environment: Windows Server 2008 and windows NT 4.0 server, MS SQL Server 2016/2014/2012/ 2008 R2/2008/2005

Confidential, San Jose, CA

SQL Server DBA

Responsibilities:

• Experience in migrating contents from MS SQL server 2008 to MS SQL server 2014/2012 and from 2012 to 2014.  
• Managed database security, creating logins, groups, users, and server level and database level roles following company policies and procedures. 
• Strong knowledge and working experience in Database Backup and Disaster Recovery. Experienced with Point-in-Time Recovery that meets company's RTO and RPO. Plan backup strategies based on the recovery models, size of data and I\O activity. 
• Design, implement and manage database maintenance and disaster recovery plans including full/differential/transactional backups and recovery procedures. 
• Implemented pre/post strategies for upgrading and migration of user databases by scripting all SQL server replications, login/users, linked servers, scheduled job, database mail profiles and server level configurations. 
• Managed efficient backup system to minimize backup/restore time by applying Database Backup Compression, enabling Instant File Initialization and applying frequent full, differential and transaction log backups.  
• Configured Log Shipping as Standby database from Production database for Reporting purposes. 
• Installed, Configured and Maintained Database Mirroring.
• Created indexes (cluster/non-clustered), constraints, views, etc . 
• Implementation of Permission, Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Monitored server activity, SQL server error logs, space usage and fragmentation and solved problem as needed.

Environment: Microsoft SQL Server 2014/2012/2008 , Windows 2008 server

Confidential, Dearborn, MI

Help Desk technician

Responsibilities:

• Provide technical assistance and support for incoming queries and issues related to computer systems, software, and hardware.
• Respond to queries either in person or over the phone.
• Install, modify, and repair computer hardware and software.
• Resolve technical problems with Local Area Networks (LAN), Wide Area Networks (WAN), and other systems.
• Clean up computers.
• Run diagnostic programs to resolve problems.
• Gain feedback from customers about computer usage.
• Install computer peripherals for users.
• Run reports to determine malfunctions that continue to occur.
• Follow up with customers to ensure issue has been resolved.
• Ask questions to determine nature of problem.