SUMMARY

• 6+ years of experience in SQL Database Administration/development, BI solutions with Microsoft® SQL Server™ Integration Service (SSIS) and Reporting Service.
• Experience in installation, upgrade and configuration of MS SQL Server.
• Strong relational database and ETL capabilities using SQL Server 2005/2008 Business Intelligence Studio and SQL Server Management Studio.
• Experience in analyzing and designing of the software development life cycle
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in MS SQL Clustering, Replication and Log Shipping.
• Experience in Performance Tuning and Database Consistency Checks using DBCC commands.
• Provided system analysis, design, development and deployment of BI applications.
• Experience in Debugging Stored Procedures and Triggers, Troubleshooting database issues.
• Designed and maintained project databases using SQL; ensured accuracy of information and automated numerous functions.
• Created and implemented database design solutions in collaboration with programming team. Analyzed and optimized MS SQL Server production databases.
• Excellent analytical, Interpersonal and Communication skills, fast learner, hardworking and versatile team player.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, by Browse to Save">SQL Server Management Studio, DTS, SSIS, SSRS, SSAS

Database: MS SQL Server 2008/2005/2000 , MS - Access

Language: T-SQL, C#

Operating System: Windows XP/07/08/NT/2000,Windows Server 2003

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

SQL DBA/Database Analyst

Responsibilities:

• Works to ensure that the associated software and hardware resources allocated to the databases deliver high resiliency and performance.
• Proactively monitors the database systems to ensure secure services with minimum downtime.
• Collaborates with the business to gather detailed business requirements for reporting.
• Uses extract, transform and load (ETL) technologies to import data from transaction systems and other sources in to the operational data store for reporting.
• Supports the design, development and management of all core business intelligence and reporting systems.
• Troubleshoots and resolves problems related to user-based SQL development.
• Improves and maintains the databases to include rollout and upgrades.
• Implements and releases database changes according to agreed timescales and costs.
• Works with the company user community to ensure accurate, current information is available to the users.
• Provides technical support to users including troubleshooting hardware/software and integration problems.
• Provides advanced troubleshooting for applications and systems, determining cause and effect.
• Mentor fellow IT colleagues.

Environment: Windows 2008 Advanced Server, SQL Server,2005, 2008 Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, SSIS, DTS Designer Tools

Confidential, Bellevue, WA

Reporting Analyst

Responsibilities:

• Assist in design and implement enterprise reporting and business intelligence solutions.
• Demonstrates their knowledge of the business processes in their area of responsibility and can work with the Business to define requirements that will drive efficiencies in the business taking into account the entire picture as well as the details
• Support building the enterprise data warehouse and extract data for analysis.
• Managing and Admnistering SSIS and SSRS. Trouble shooting issues related to their failure.
• Documentation and Analysis of data on Hadoop and DB2.
• Has the ability to conceptualize, document, and communicate solutions to meet business objectives.
• Develop ETL using SQL Server Integration Services (SSIS) and Report development using SSRS. OLAP design and build.
• Configure Reporting Manager for subscription, email notification, drill down reports, data sources and users security
• Management of own task list and appropriate prioritization within overall team, department and company requirements.
• Maintain documentation for changes/enhancements to reports.
• Provide regular reporting to management on progress and ensure that critical items are escalated as appropriate.
• Trouble shooting database issues and worked on performance tuning.

Environment: Windows 2008 Advanced Server, SQL Server,2005, 2008 Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, SSIS, DTS Designer Tools, Hadoop, DB2

Confidential, Redmond, WA

SQL DBA and BI Admin

Responsibilities:

• SQL Server 2005/2008 development and Administration on Multiple Server Environment
• SQL Server Performance Tuning, SQL maintenance, networking and deployment management
• Took a huge responsibility in Administration and development of SSIS and SSRS.
• Extracted and Transferred data from different sources(e.g. Text File, Excel) to SQL Server DB and vice versa
• Troubleshooting and break/fix for incidents and supporting live site.
• Created Proper Indexes to support performance of queries
• Performed data compiling, Mining and Analysis required to evaluate the given data
• Determine the methodologies and procedures for carrying out effective data analysis
• Extract data from the relational database and prepared reports.
• Monitored database size growth and resolved log space issues
• Troubleshooting and break fix for incidents related to Databases/BI
• Working on load capacity issues to structure jobs to run efficiently and effectively
• Alert Analysis, Change/Add/Remove Alerts, Triggers, Scripts
• Analysis of source systems and developing mappings to extract data into a data warehouse environment.
• Migration of SQL 2005 to SQL 2008
• Worked on log shipping, replication and other disaster recovery techniques.
• Business Intelligence Administration and development.

Environment: Windows 2008 Advanced Server, SQL Server,2005, 2008 Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, SSIS, and DTS Designer Tools

Confidential, Redmond, WA

SQL DBA

Responsibilities:

• SQL Server 2008 development and Administration
• SQL Server Performance Tuning
• SQL maintenance, networking and deployment management
• Worked on different escalation issues. Helped customers in understanding the application and solved database related issues.
• Debugging stored procedures.
• Installation of operating system and SQL server 2008 (Cluster and Standalone)
• Created tables, stored procedures, and triggers and writing heavy duty queries.
• Solved the performance of slow running queries.
• Installed Looking Glass application and experience on the maintenance of the application
• Created virtual machines and installed different applications
• Virtual Machine management on windows 2008, R2
• Solved disk space issues and worked on disaster recovery planning

Environment: Windows 2008 Advanced Server, SQL Server,2005, 2008 Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, SSIS, DTS Designer Tools, Looking Glass.

Confidential, Redmond, WA

Database System Analyst

Responsibilities:

• Worked closely with the Microsoft project team during the planning, configuration and testing of database connections to Microsoft Amalga Application.
• Worked on Amalgam system configuration and give Support on Data base administration to healthcare enterprises, providers, researchers, and hospitals
• Implemented and maintained a backup and disaster recovery plan.
• Configured systems for clustering and backup/restore processes.
• Worked on installation of SQL( multiple instances) on Virtual Machines ( Hyper-V)
• Monitored and maintained appropriate disk storage requirements for the database
• Set up Peer to Peer Replication, transactional and merge replication.
• Supported application testing and insured proper database operation
• Writing new Stored Procedures, T-SQL scripts, User Defined Functions (UDF) and Modify existing ones and tune them to perform well.
• Maintained an ongoing configuration design and documentation for the databases
• Performed routine tasks such as purging old files and checking disk space
• Resolved database issues and implemented performance tuning techniques.
• Administered SQL Reporting Services and create/maintain SQL reports and Worked on SSIS (DTS)

Environment: Windows 2008 Advanced Server, SQL Server,2005, 2008 Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, SSIS, DTS Designer Tools, Amalga application.

Confidential, Omaha, NE

SQL DBA

Responsibilities:

• Supported the design of new Relational Database System for windows performance (SQL Server 2005)
• Created several Stored Procedures, triggers, user defined functions (UDF), views to implement the business logic.
• Fixed performance issues associated with stored procedures and queries.
• Extracted data from the relational database and prepared reports.
• Built database environments based on performance optimization
• Installed SQL 2005/2008(active/active and Active/passive)
• Supported web hosting environments: including adding/deleting web sites, web site performance monitoring and tuning, building/supporting web servers. Working on IIS.
• Transactional Replication and Merge Replication and maintaining replication errors.
• Applied Backup and restore mechanisms.( Also familiar with Light speed backup software)
• Involved in maintaining of Stored Procedures, Functions and DTS Packages, enforced database triggers for auditing.
• Managed web servers and worked on Configuration of different features on websites using IIS.

Environment: Windows 2003 Advanced Server/Server 2003, SQL Server 2000,2005, 2008 Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, SSIS, DTS Designer Tools, Windows Performance Monitor QUEST Tools.

Confidential

SQL DBA

Responsibilities:

• Experience in migration and support of databases for Production, Integration and Development environments ( Dedicated & Shared Databases)
• Migration of databases from MS SQL server 2000 to MS SQL server 2005.
• Migration of oracle 9i to 10g
• Experience in Implementation of Production, Integration and Development environment, Hardware requirements andsupport
• Worked extensively on installation, upgrade and configuration of MS SQL Server 2005 and MS SQL Server 2000 databases/ servers.
• In migration process involved into PAR Review, Migration Review, preparing documentation for reviewing process and migration, request for backup, migration, providing active support after migrations.
• Creation and maintenance of Users security permissions and Migrating the entire database objects from one server to another server.
• Extensive exposure to creation of databases, objects, stored procedures, triggers, security, DTS (i.e. Import and Export), BCP, Transact-SQL, and SQL Server Agent and SQL Server profiler.
• Implemented disaster recovery for SQL Server Production Database.

Environment: Windows 2000 Advanced Server/Server 2003, SQL Server, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, SSIS, DTS Designer Tools, Windows Performance Monitor.

Confidential, VA

Junior SQL Developer

Responsibilities:

• Worked closely with Business Analysts and Application Developers to produce all required documentation.
• Involved in all analysis of documents to create layouts for conversion purpose
• Creating mapping documents from legacy system to new one
• Performed field level analysis to determine whether a field needs to be converted from legacy to new system based on requirements
• Developing ETL packages/scripts using DTS and stored procedure for data loading
• Extensive use of T-SQL statements to write complex queries.
• Proper use of Indexes to enhance the performance of individual queries and enhance the stored procedures

Environment: Windows 2000 Advanced Server/Server 2003, SQL Server, Enterprise Manager, Management Studio, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, SSIS, DTS Designer Tools, Windows Performance Monitor.

Confidential

Assistant Junior Database developer

Responsibilities:

• Assisted in creating and maintaining databases, table spaces, users, tables, indexes, store procedures, roles, profiles, partitions and other schema objects.
• Performed backups, DBCC utilities, updated index statistics, monitored database and disk space. Involved in security issues and scheduled tasks.
• Assisted in creating maintenance plan for optimization and integrity check for all SQL servers.
• Developed forms and generated reports in Access, as requested by the staff.
• Developed Access Database, gathering data from excel sheets and word formats, and Access tables and Used VBA codes and SQL queries to pull data from the different data sources and build data entry forms

Environment: SQL Server 2000, Windows 2000 Server, Windows 2000 Advanced Server, Log Shipping, MS-Windows 98, MS-Dos, MS-office Packages 2000: MS-Word, MS-Excel, MS-Access