OBJECTIVE:

Design, develop and implement database - driven online applications. Perform database administration tasks.

TECHNICAL SKILLS:

• Windows Server
• SQL Server 2000 - 2016
• .NET
• IIS
• C#
• VB.NET
• HTML
• XML
• PowerShell
• TFS
• SSIS
• SSRS
• SSAS
• Windows Azure
• Oracle
• MySQL
• UNIX/Linux

PROFESSIONAL EXPERIENCE:

International IT CONSULTANT

Confidential

Responsibilities:

• Helped in converting a variety of business needs to IT solutions.
• Made recommendations on hardware and software requirements for the projects.

SQL Server developer

Confidential, Redmond, wa

Responsibilities:

• Contributed to the development of MS Retail Group Data Warehouse Project and the sustainment of Windows Phone on both on-premises SQL Server databases and Windows Azure SQL Server databases.
• Performed logical and physical database design.
• Created table schemas according to project functional specifications.
• Added indexes on tables.
• Created stored procedures, UDFs and triggers using T-SQL.
• Designed and modified existing SSIS packages for ETL tasks.
• Created rollout and rollback builds in Team Foundation Server.
• Optimized existing stored procedures for performance improvement.
• Worked with customers to ensure optimal operation of SQL Server databases and related services.
• Investigated failed infrastructure systems to define the impact of outages and technical requirements of development while offering suggestions for solutions and improvement.
• Resolved bugs.
• Created or modified deployment instructions.

sql server dBA

Confidential, bellevue, wa

Responsibilities:

• Contributed to the development and maintenance of Confidential online advertising solutions through all stages of SDLC.
• Collaborated with software architects and developed data architectural strategies at the modeling, design, and implementation phases to meet or exceed business requirements.
• Created logical data models and translated them into physical database structures that integrate with new features and functionality.
• Created, modified and debugged stored procedures, functions and triggers.
• Optimized stored procedures and batch jobs to resolve performance bottleneck.
• Developed best practices for data extraction, transformation and loading into and out of the data warehouse using SSIS.
• Maintained high availability by implementing SQL Server failover clustering, log shipping and database mirroring.
• Designed disaster recovery plans and performed database backups & restores.
• Ensured prioritization and resolution of production bugs in TFS.
• Identified the root causes of database issues and provided remedies that prevent them from reoccurring.
• Created hot fixes for bugs' resolution.
• Managed day-to-day activities of offshore team members.
• Used TFS for source control.

database ENGINEER

Confidential, issaquah, wa

Responsibilities:

• Managed daily activities in coordination with developers and test engineers to meet the deliverables and schedules of data solution components within the Web application project.
• Performed logical and physical database design in OLTP environment.
• Created automation builds and managed deployments of new releases
• Used T-SQL to create stored procedures, views, triggers and ad-hoc queries.
• Designed SSIS packages used for ETL operations.
• Contributed to the data warehouse project using SSAS.
• Set up SSRS in scale-out deployment and designed reports.
• Optimized stored procedures using query execution plan analysis, SQL Server

database ENGINEER

Confidential, belleuve, wa

Responsibilities:

• Maintained SQL Server 2000/2005 databases supporting various online market research applications on Windows 2003 servers.
• Maintained Oracle 10g database for a financial application on Solaris server.
• Re-evaluated the company database architecture and separated reporting datasets from OLTP database.
• Implemented high availability solution by setting up 4-node SQL Server 2005 failover cluster.
• Set up transactional replication to remote servers.
• Optimized stored procedures and increased overall system performance.
• Performed ETL operations using SSIS packages.
• Set up SQL Server Reporting Services, and created reports.
• Owned SQL Server Agent jobs and processes and provided errors troubleshooting.
• Developed, tested and implemented new disaster recovery plans.
• Created Windows and UNIX Shell scripts.
• Improved database security by implementing new security structures.
• Maintained documentation of procedures and processes.

database ENGINEER

Confidential, redmond, wa

Responsibilities:

• Supported MSN AdCenter IT operations in a pre-production and production environments.
• Designed and implemented new database architecture.
• Maintained very large databases in both OLTP and OLAP environments.
• Migrated SQL Server 2000 databases to SQL Server 2005 instances.
• Created and tuned stored procedures and functions.
• Created DTS/SSIS packages for ETL operations.
• Set up replication between servers.
• Maintained high availability by implementing SQL Server failover clustering, log shipping and database mirroring.
• Resolved database issues, and contributed to the delivery of high quality services.
• Created and deployed hot fixes in pre-production and production environments.