SUMMARY:

More than 10 years of database design, development and administration experience in MS SQL Server 6.5, 2000, 2005, 2008, 2012 and industrial experiences in legal, healthcare insurance, manufacturing, software and financial etc.. An industrious, versatile team player with good Communication skill and has a demonstrated tracking records of getting things done in time and to the users’ satisfaction.

TECHNICAL PROFILE:

SQL Server: SQL server 6.5, 7.0, 2000, 2005, 2008, 2012 & 2014, IBM Informix

Reporting Tools: SQL server reporting services 2005 & 2008 R2

Data warehouse Development tools: MS Visual studio, SQL Server Analysis Services

Third Party Monitoring Tools: SQL Sentry, Idera, Ignite, Redgate, Spotlight, VMware vSphere Client, etc.

WORK EXPERIENCE:

Confidential

Sr. SQL Server DBA

Environment: Windows 2008 R2, 2012 R2 servers, SQL Server 2008 R2, 2012 & 2014, SQL server 2012 & 2014, High Availability, Windows clusters environment. Financial software include Portia, Charles River, Tradeflow, Epicor etc. SQL server monitoring tools: SolarWinds, ignite, SQL sentry.

Responsibilities:

• Provided support to production, UAT and dev environments and ensure healthiness of all the environments; Responsible for the databases migrations and SQL server upgrade
• Provided support to financial and accounting departments for month/year end process
• Provided support to financial application vendors Cadis, Portia, Charles River, Tradeflow and Epicor during software upgrade and helped vendors to diagnose the production issues incurred from the upgrades;
• Responsible for applying SQL server security patches & service packs on standalone and clusters, managing security and permissions; Ensure all the production backup schedules meet by the business RPT requirements
• Performed trend analysis and system capacity planning; Monitor and optimize database performance; Assisted vendors and the firm dev teams with suggestions for better query performances
• Performed database compression and SSIS migration
• Provided support for SSAS, ETL processes and responsible for performance tuning
• Created SSRS reports and Provided supports for the existing SSRS reporting system
• Responsible for infrastructure design for the new environment
• Created an automated centralized SQL server alerting system using PowerShell for the firm to replace the existing individual daily health check alerts.

Confidential

Sr. SQL Server DBA

Environment: Windows 2008 servers, San, SQL Server 2008 R2, 2012 & 2014, High Availability, Windows clusters, Replication, Geo multisite clustered environment

Responsibilities:

• Responsible for monitoring production environment, db file growth etc.
• Maintained more than 6000 dbs and Terabytes db backups
• Code review and performance tuning
• Responsible for DR tasks and provided 24/7 support with on call rotation
• Creating and scheduling CDC data feed for SSRS reports
• Automating jobs using PowerShell & SSIS
• Build SSRS reports for managers and clients
• Establish ETL processes to transfer files between different domains using SSIS
• Install, upgrade, consolidate and maintain SQL Server 2008 R2 and SQL Server 2012 environments for Production, Development and QA
• Established a procedure to transfer backup files from local disks to IOMEGA disks.
• Troubleshoot production issues, diagnosed root cause analysis and provided preventative recommendations

Confidential

Sr. SQL Server DBA

Environment: Windows 2008 servers, San, SQL Server 2008 R2, SQL server 2012 & 2014 Asp.net, C#, IBM Informix servers, Server studio, DBMoto

Responsibilities:

• Performing daily DBA routine tasks such as reviewing logs files, resource/system monitoring, ensure all SQL server full and log backup jobs or other schedules in successful status. Ensure the integrity of the production environments
• Setup and monitoring SQL server mirroring and replications
• Responsible for tuning and production troubleshooting and Provided 24/7 production support and on - call rotation support
• Monitoring and identifying problem queries by using third party tool ignite. Query optimization for SQL server and IBM Informix server
• Responsible for all QA, staging and production releases
• Responsible for installing new versions of SQL servers and applying the latest SQL server security patches
• Migrating and modify SSIS scripts and jobs from older SQL server environment to the new environment
• Identify and automate SQL server tasks and alerts such as users login, critical system failure alert, etc
• Configured, setup and maintained reporting service website
• Coordinate between different project teams and Provided DBA support
• Created database models using Erwin case tool for production databases
• Responsible for DR scripting and test

Confidential, New York

Sr. SQL Server DBA

Environment: Windows 2003 & 2008 servers, Clustered environment, San, SQL Server 2008 R2, SQL server 2012 Asp.net, Java

Responsibilities:

• Performance tuning and production troubleshooting and Provided 24/7 production support and on-call rotation support for over 100 virtual servers
• Responsible for enterprise level of data center migration tasks; Outlining the migration procedures and details; Preparing the SQL server migration scripts; Performed migrations
• Install and configure SQL servers, setup transactional replications; Responsible for data center migration preparation, migration and scripting tasks
• Responsible for diagnosing production issues and provided solutions.
• Upgrade SQL server from SQL server 2005 to SQL server 2008 R2 and from SQL server 2008 R2 to SQL server 2012; Create, modify and migrate SSIS.
• Performed database migrations and SQL server upgrades on production servers
• Performed recovering databases to the point of failure using transactional backups
• Responsible for staging and production releases
• Setup alerts for all productions SQL servers to monitor performance, resource usage, failed jobs, etc.
• Setup DR environment (database mirroring) for outlook messaging teams
• Provided support to all developers’ requests, Created ssis and responsible for ssis production migrations and Provided SQL coding recommendations to developers for better performance
• Creating/modify existing production procedures for better performance
• Creating virtual website, configure IIS, setup website dev, staging and production environments for attorney annual review, recruit and admin staffing annual reviews worldwide.
• Configure user single sign-on for the firm website
• Setup and maintain websites; Configured Kerbero authentication for SSRS site Responsible for website user access rights: responsible for assigning admin, solicitation, gatekeeper roles, etc. for restricted admin website access
• Creating a system to monitoring user login and activities
• Provided daily web support for firm’s intranet applications
• Handling all production application tickets

Confidential, New York

Sr. SQL Server DBA

Environment: Windows 2003 & 2008 servers, Clustered environment, San, MS SQL Server 2000, 2005 & 2008, Asp.net

Responsibilities:

• Performance tuning and production troubleshooting
• Generating new dbs for new clients through copy client procedures
• Tuning stored procedures
• Creating ad hoc complex management reports as required.
• Designing and developing reports using SQL server reporting services 2005&2008
• Designing and developing data warehouse cubes
• Interacting with business users to resolve application issues and performing data upload requests
• Performed as a technical lead for HRPortal DBA support team to allocate DBA tasks to team members and ensure the tasks being completed successfully in a timely manner.
• Building new DR environment and replication environment
• Provided 24/7 production support in clustered environment for over 60 SQL servers and Provided scale up or scale out suggestions to the management
• Detecting the causes and troubleshooting high cpu, disk space, blocking, deadlock, top running queries that used the most resources
• Storage planning for annual AE production, development and QA environments
• Troubleshooting production maintenance jobs issues
• Coordinating with team members and delegate production tasks
• Creating SSIS to automate production import and export tasks
• Setting up transactional replications, ensuring high availability and excellent performance for all production servers
• Manage database security and user login requests

Confidential, New York

SQL Server DBA

Environment: Windows 2000 Servers, Clustered environment, San, MS SQL Server 2000, 2005 & 2008, Asp.net

Responsibilities:

• Company application supports and troubleshoot
• Data modeling, database design and development
• Creating stored procedures, views, triggers and functions
• Creating ad hoc complex management reports as required.
• Designing and developing reports using SQL server reporting services
• Designing and developing data warehouse and Provided trend analysis reports to the management
• Interacting with users to resolve application issues in a timely manner
• Creating SSIS and schedule the task to import and export files
• Provided 24/7 production support in clustered environment for over 40 SQL servers
• Ensure the healthiness of the production environment and troubleshoot production performance issues and provided solutions
• Created disaster recovery plans
• Responsible for production releases, log shipping and replication configuration
• Responsible for installing SQL server 2000, 2005 and 2008 and applying security patches
• Created the first data encryption application for the firm
• Created a comprehensive monitoring SQL server systems that will sent out alert daily to check data integrity, disk space and production job status using distributed transactions
• Migrated over 100 SQL databases from SQL server 2000 server to 2005 Servers
• Converted over 1000 dts to SSIS
• Maintained over 40 servers in good standings
• Created and maintained data warehouses cubes

Confidential, New Jersey

SQL Server DBA

Environment: Clustered environment, MS SQL Server 2000&2005, Asp.net

Responsibilities:

• Provided support to developers and business users
• Data modeling, database design and development
• Creating stored procedures, views, triggers and functions
• Creating ad hoc complex management reports as required
• Designing and developing reports using SQL server reporting services
• Designing and developing data warehouse cubes and provided trend analysis report to the management
• Provided 24/7 DBA production support in clustered environment and responsible for production releases
• Troubleshooting performance issues
• Responsible for all production databases maintenance jobs
• Troubleshoot and fix failed production jobs
• Maintain all production servers in good standing

Confidential

System Engineer (SQL Server Database Administrator)

Environment: Java, VB, VBA, Asp.net (vb.net, c#), XML, ASP.net, Java Applets Servlets, MS SQL Server 2000, MS Access

Responsibilities:

• Developed DTS packages, stored procedures, triggers, functions and views
• Performed database backups and maintenance
• Lead database developer: designed and developed databases for company Websites
• Coding in java for satellite and radio communication application
• Data Warehouse design and development: designed and developed OLAP cubes