SUMMARY

• One real Microsoft SQL Server DBA and developer veteran who has over six years of focused experiences in Microsoft SQL Server administration and development area in various fields like financial, telecom, and manufacturing.
• Extensive experience in SQL Server database design, analysis, modeling, development, administration, implementation, trouble shooting and quality management.
• Involved with the architect group in designing the logical and physical model of the enterprise level databases. Have impeccable communication and interpersonal skills and an exceptional team player.
• More than six years’ working experience in SQL Server database administration, 6+ Years’ experience in SQL Scripts.
• Three years experience in SDCL, working with other team to evolve application development solution.
• Very strong in the development for Microsoft SQL Server(stored procedures, views, scalar - valued and table-valued functions) by using T-SQL.
• Extensive experiences in Microsoft SQL Server database administration, including designing, implementing, maintaining and documenting complex database applications and data warehouse system.
• Solid first-hand experiences with Data modeling and Database Logical /physical Design.
• Strong experiences with MS SQL Server clustering, data warehousing, and data extraction/transformation/load.
• Deep understanding and solid skills in MS SQL Server Log shipping, Database Mirroring, snapshot/transactional/Merge replication, Failover cluster, BCP, DTS and SSIS, SSAS and SSRS.
• Experience with MS SQL Server based reporting tools like SSRS and Crystal Reports.
• Develop and implement policies, procedures and standards for preserving the integrity and security of data, reports and access.
• Proficient with SQL Server Management Studio, SQL Server Business Intelligence Development Studio, SQL Profiler, Performance Monitor.
• Experience with installing, configuring, analyzing, and supporting SQL Server 2005, 2008, 2008R2, 2012 and 2014 in Development, Test and Production Environment.
• Strong experience with SQL Server upgrade, full / differential / log backup & recovery, clustered/non-clustered index, locks including live locks/dead locks.
• Extensive experience with writing SQL scripts, stored procedures, triggers and functions, creating SQL Server Jobs/alerts, and scheduled tasks to automate tasks.
• Strong experience with server/database/scripts Performance tuning and optimization.
• Experience with monitoring, troubleshooting and resolving database issues in 24×7 production Server.
• Strong experience with SQL Server performance monitor and performance tuning, maintenance and SQL Server version upgrade.
• Excellent knowledge with SAN Storage and Storage Capacity Planning.
• Experience with Amazon AWS, RDS (SQL Server) and S3/EBS storages.
• Experience with Visual Studio and Microsoft SharePoint platform.
• Good Knowledge of system monitoring software (Zabbix/Nagios/Solarwinds)
• Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks.
• Excellent communication skills. Proactive, independent, self-managing and teamwork spirits.
• Experienced on 7X24 On-call Service.
• More than 6 years experiences of OS skills in Windows platform.
• Microsoft SQL Server DBA Certificate

TECHNICAL SKILLS

Database: MS SQL Server 2008/2008R2/2012/2014, MySQL 5.0/ 5.1 / 5.5 / 5.6 , Oracle 11g/12c

Language: SQL and T-SQL, C/C++/C#, Java, PowerShell, HTML, CSS, XML, Javascript

Tools: Microsoft SSRS/SSAS/SSIS, Profiler, Visual Studio/ SharePoint/Agile

Development: Git / Subversion / JIRA / Rally

Application: Apache/IIS/Tomcat, FTP, Samba, DNS, Firewall, VPN, VMware

Monitor System: Zabbix; Nagios; Solarwinds; Graphite; New Relic

PROFESSIONAL EXPERIENCE

Confidential, Gainesville, FL

Senior Microsoft SQL DBA Consultant

Responsibilities:

• Worked closely with Systems Administrators and Development teams to Administer - install, upgrade, migrate and troubleshoot Prod and non-prod SQL server instances across both physical and virtual machine (VMware) environments
• Administered over 50+ SQL servers
• Worked with other team to develop web server application using Agile SDLC).
• Migrated several PROD database servers with minimal downtime
• Supported reporting applications, and other sub systems dependent on SQL server
• Monitor production databases for performance, availability and data integrity
• Configure and maintain database replication, log shipping and nightly processes
• Scripted several database maintenance tasks reducing manual processes and related overheads
• Performed data recovery from corrupt databases or simple backups or transaction logs
• Set up SQL/database mail to produce database health reports and other alerts
• Managed production deployments of schema changes and data conversions
• Created SSIS packages for data transfers, Import/Export and Migrations
• Recreated indexes, optimized queries, memory management to improve performance
• Database space management, log files and data integrity
• Created and managed full-text server, linked servers to support production needs
• Administered SQL server security and kept up-to-date through frequent audits of SQL logins
• Tested and installed latest SQL server / Windows server service packs on all SQL servers
• Integrated SQL Server with Windows Active directory security for database/table level permissions
• Created strong passwords for SA account, sometimes disabled it, remove sample databases
• Ran Microsoft Baseline security analyzer periodically to check for SQL server security issues
• Worked on database maintenance (including DB changes, DB patch, DB index tuning)
• Managed SAN system
• Monitored Windows/Linux system using Nagios and Zibbix software
• Documented DB structures and functionalities.

Confidential, Deerfield, IL

Sr. Microsoft SQL Database Administrator

Responsibilities:

• Managed and Optimized more than 50 MSSQL Servers (SQL Server 2005/2008) boxes setup and managed high availability strategy: failover cluster, replication, database mirroring and log shipping
• Configured SQL Server maintenance plans to automatically back up SQL Server Databases, optimize index and update statistics
• Collaborated with infrastructure team for database backup strategy: onsite backup, offsite backup and offline backup
• Used SQL Server Profiler to trace long running queries for optimizing databases
• Restored MSSQL Backups to check backup integrity and practice disaster recovery
• Troubleshot SQL Server related CPU/Memory, I/O using Performance Monitor
• Wrote MSSQL codes including stored procedures, functions, and triggers.
• Managed MSSQL data warehouse, Wrote SSIS for ETL tools, SSAS for data analysis, SSRS for reports.
• Collaborated with system teams and development teams for codes release including MSSQL database changes and patches.
• Set up and configure Zabbix monitor system and Solarwinds to monitor SQL Server system, Windows Application systems and Linux systems.
• Upgraded SQL Server 2008R2 to SQL Server 2012.
• Created and managed full-text server, linked servers to support production needs.
• Documented All MSSQL Database structures and functionalities.
• Worked with Auditors and Provided Database related documents.
• Worked on 7X24 on-call rotation.

Confidential, Bensenville, IL

Microsoft SQL DBA Consultant

Responsibilities:

• Installed, configured, administered and secured SQL Server 2008/2008R2 on Server and Clients.
• Gathering and Suggesting of Storage (SAN) with future analysis for top notch performance and redundant.
• Managed Logins, Users, Roles and User permissions, and conducted backup and recovery
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Installing TDP and Control-M agents for SQL Backup according to the norms.
• Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
• New SQL Server 2008 R2 installations on VMware host servers and Hypervisor environments.
• Developed administrative tasks of SQL Server of performing daily Backups and recovery procedures
• Implemented high availability techniques mainly Replication, Log shipping and involved in planning and monitoring Log Shipping.
• Performance monitoring and taking steps to improve the I/O throughput is one of the most important factors when setting up SQL Server VMs.
• Suggesting the right hardware for hosting SQL Server on Hyper-V
• Installed and Configured Transactional and Snapshot Replication for production servers to other production servers available in remote location
• Successfully implemented Database Mirroring with High Availability Mode in SQL 2005 and installed SQL Server in a cluster Environment.
• Created alerts and notifications for system errors, insufficient resources, and fatal database errors.
• Migrated from SQL Server 2005 to SQL Server 2008R2. And migration of SSIS packages to SQL Server 2008R2.
• Migrated SSRS Reporting Server from R2 SQL Server.
• Running DBCC Consistency Checks and fixing Data Corruption in user databases.
• Helped developers team in developing and deploying SSRS packages.
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation.
• Heavily used Transactional Replication, Configured between Primary Server and three Read - Only servers and experience in troubleshooting replication problems.

Confidential, Charlotte, NC

Microsoft SQL Developer & DBA Consultant

Responsibilities:

• Worked with Business Analysts on translating user’s requirements into development plan.
• Created monthly KPI reports for different departments using pre-created stored procedures.
• Created cubes that enable users to create pivot table in Excel using cube data.
• Loaded raw data from flat data files into SQL Server 2008R2 database tables using DTS package, bulk insert, and table export/import wizard.
• Established linked server to retrieve data from distributed SQL server, connected to diversified data source with OLE DB provider or ODBC provider.
• Created clustered index and non-clustered index to tables in order to improve query performance.
• Granted SQL Server Database security and Report Server security to end users.
• Integrated data from Heterogeneous data sources (Flat file, Excel, Access, Oracle, distributed SQL Server) to centralized SQL Server database using SSIS package (ETL), including data validation, data massage, transformation, data cleanse, formatting, mapping and auditing.
• Maintained and enhanced the existing Data Warehouse, exports and reports; developed vendor and client exports that meet provided specifications.
• Performed quality checks on reports and exports to ensure exceptional quality; monitored jobs and transfer queues to ensure they were functioning as expected.
• Supported reporting applications, and other sub systems dependent on SQL server.
• Migrated the existing MS Access reports to SSIS/SSRS and developed new SSIS/SSRS packages to meet business needs.
• Provided business users the data required for metrics and analysis; created and maintained documentations for all related projects.
• Participated in the full life-cycle development process from definition and design to production delivery.
• Developed different applications using T-SQL and analyzed functional requirements and developed software programs to specifications.
• Set up SQL/database mail to produce database health reports and other alerts.
• Managed production deployments of schema changes and data conversions.
• Recreated indexes, optimized queries, memory management to improve performance.
• Ran Microsoft Baseline security analyzer periodically to check for SQL server security issues.