Sr Developer/DBA

AMELIA MONICA DAVID

713-***-****  ******.*******@*****.***

SQL DATABASE ADMINISTRATOR/DEVELOPER/.NET DEVELOPER

HIGHLY ACCOMPLISHED, DEEPLY DRIVEN, RESULTS-ORIENTED SOFTWARE PROFESSIONAL with a successful 6+ years of experience in MS SQL Server Administration / Development/.NET Development, performance optimization, business intelligence, Software Development Life Cycle and object oriented analysis. Proven ability to tackle and succeed in all endeavors from business development to customized software development and implementation. Repeatedly successful in navigating complex technical environments and possess strong designing and implementing Database Systems despite the challenges of changing priorities, imminent deadlines and differing team agendas. Handle multiple assignments simultaneously with analytical mindset and coordinate deliverables with key stakeholders in cross-functional groups.

TECHNOLOGY SNAPSHOT: MS-DOS, Windows 95/98/XP/Vista and 2000 Professional, C, C++, ASP. Net, Java, JavaScript, HTML, Microsoft Office and Microsoft Visual Studio.

KEY SKILLS

• Administrated 20+ SQL Server Database.

• Migrated / Upgraded SQL Server Database.

• ASP. Net • Indexing

• SSIS, SSRS, DTS and Replication.

• Monitoring and Optimizing performance.

PROFESSIONAL EXPERIENCE

Interim HealthCare, Sunrise, FL – Nov 07 to Feb 10

RedBlackTree

SQL Database Administrator/Developer and .Net Developer

RedBlackTree has established them in a very short span of time as a technology leader within the American Healthcare Services industry. InterLink is a Web-based software that allows to increase profitability and cash flow, improve compliance and optimize utilization - while decreasing overtime and eliminating unauthorized services. It is been used by all the healthcare providers, skilled/un-skilled workers and patients of Interim HealthCare all over US. This application provides lot of features from enrolment, maintaining employees’ and patients’ records, billing and insurance details of the customers which can be accessed at anytime, anywhere, from any PC that has an Internet Connection. It also provides an excellent Support System which enables the users to report any issues with the application, which delivers an alert message to our developers for immediate resolution.

Environment: SQL Server 2008/2005, T-SQL, .Net Framework 3.5/2.0, VB.Net, JQuery, JavaScript, AJAX, CSS

• Participated in Design and Architecture meetings and proposed technical solutions to resolve business requirements.

• Worked closely with the development team in meeting the deadlines pertaining to design and development deliverables.

• Followed the Microsoft recommended best practices in designing, developing, implementation and testing of the ETL using SQL Server Integration Services.

• Used DBA Repository Database to monitor all SQL Server Instance and Report them using SSRS.

• Followed vendors best practices in Installing and upgrading the SQL Database server and application tools.

• Allocating system storage and planning future storage requirements for the database system.

• Creating primary database storage structures (tablespaces) after application developers have designed an application.

• Creating database objects like tables, views, indexes, stored procedures, functions and triggers.

• Modifying the database structure, as necessary, from information given by application developers.

• Creating users and maintaining system security.

• Created different user level groups, and assigned appropriate permission levels to the reports, to ensure access to the information for the right persons with authorizations based on their levels in the Organizational hierarchy.

• Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes using Performance Monitor, Profiler, and Database Engine Tuning Advisor.

• Monitoring and optimizing the performance of the database using system and third party tools.

• Planning for backup and recovery of database information.

• Implemented and used linked servers for distributed queries.

• Implemented SQL Server 2005 password policy.

• Both Client side and Server side scripting was accomplished using VB Script.

Support System, Sunrise, FL

SQL and .NET Developer, May 06 to Nov 07

Worked with a team of 4 developers to build a Support System, a web-based application tool as a component of an existing Management System to help the end-users report any issues that occur when using the system. This system enables the users to add notes, attachments(image or data file) and thus provides an efficient method to handle issues for both end-users and helpdesk team. The issues can be assigned to different developers and the status of the issues can be changed (New, Research in progress, Resolved) which helps the end-users to find whether their issue has been resolved. It also has a dashboard page for count of issues that are opened and closed every day.

Environment: SQL Server 2005, T-SQL, .Net Framework 3.5, JavaScript, Web Services

• Installed and configured SQL Server 2005 on Windows 2003 server and fully documenting the install procedures so that SQL Server Instance can be reproduced during emergency.

• Performed upgrade of SQL Server 2000 – SQL Server 2005 using SQL Server upgrade advisor.

• Worked with ASP, HTML, JavaScript, CSS, and MS SQL Server to develop the product.

• Day to day maintenance like checking OS Event logs, SQL Server logs and security logs for unusual events.

• Monitoring disc space to track disc usage on the server.

• Used SQL Profiler to monitor and identify blocking issues.

• Create SQL Server Alerts to monitor and notify SQL Server potential problems.

• Design the application to meet the users’ requirements document.

• Used tools like Idera and Quest for SQL Server to manage SQL Servers.

• Created views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages.

• Analysis and design of databases and user interface.

• Analysis, Design and Implementation of Web Services for Data Synchronization .

• Assist the Project Manager to ensure user requirements are met and that the modules are completed on time.

• Documented problems and resolutions for future reference.

• Tested code to ensure functionality.

Course Assessment System

Infotech Solutions

SQL Database Administrator/Developer and .Net Developer, Nov 05 to Apr 06

CAS, Course Assessment System, is an application, developed using VB.NET as a Front-end and SQL as a back-end for Educational Institutions. The main aim of the project is a Course Assessment System for both teachers and students. The modules in the Project were for Students recruitment purposes, Employee details maintenance, Attendance management, Allocations, transfers and deputation management, Performance-appraisal management and Leave-details management.

Environment: SQL Server 2005, T-SQL, .NET Framework

• Provide primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.

• Participated in gathering User Requirements and System Specifications.

• Installed, Maintained and Administrated SQL Server 2000 on Windows 2003 Server.

• Designed physical development databases on SQL 2000 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in developing database for contract maintenance system

• Performance Tuning: Duties include SQL Server 2000 Production, Test and Development Support as well as performance tuning and trouble shooting. Responsible for Databases Administration, Backup and Restore operations, database environment Promotion and data refresh

• SQL Profiler and SQL Trace: Participated with Ad-hoc SQL Server DBA activities and requests throughout the company as needed. Assist Development staff with SQL Server related tasks and along with review of SQL code to prevent and resolve database bottlenecks

• Wrote complex stored procedures to process drivers record and balanced the processing load between front end and back end.

• Troubleshooting DB performance issue and implementing necessary Database changes.

• Transformed data from various data sources using OLE DB connection by creating various DTS packages

• Migrated data from legacy system (text based files, Excel spreadsheets, and Access) to SQL Server databases using DTS, SQL Server Integration Services (SSIS) to overcome the transformation constraints

• Responsible for design of the Schema and finalization of naming and coding standards throughout project life cycle

Sundaram Motors

.Net and SQL Developer, Nov 04 – Nov 05

AutoPower is a comprehensive logistics and Distribution system for Automobile dealerships to optimize retail performances, while improving customer loyalty. It is a futuristic web enabled e-Business solution, embedding user and customer friendly approach, with built in features to handle change in business rules and practices, in addition to efficient handling of existing business processes. It has six versatile modules (Presales, Sales, Workshop, FinTrack, Partshop & Dealer Connect)

Environment: MS SQL Server 2000, Windows Server 2000, Microsoft Excel, C++, T-SQL, SQL Server Profiler

• Played an active role during the requirements gathering, analyzing and designing of the system.

• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data ,normalized tables, established joins and created indexes whenever necessary

• Used SQL Profiler and Index Tuning Wizard for tracing slow running queries and stored procedures.

• Developed and modified database objects in accordance with gathered requirements.

• Written database triggers and stored procedures using SQL to enforce business rules.

• Bulk loading of data from Excel data sources using DTS.

• Created appropriate roles for applying and creating users according to the profile.

• Created Stored procedures for auditing SQL Server logins and reporting anonymous logins to the manager.

• Recreated SA password and ensure it is not accessed in any application for satisfying SOX policy.

• Used Windows Global groups or SQL Server roles to manage group of users that requires similar permission.

• Involved in defining and setting up permissions for user access.

• Involved in tuning the SQL Server application using profiler.

• Designing Linked servers to data Import.

• Involved in fine tuning of SQL queries and optimizing the data models for reporting.

EDUCATION

MASTER OF COMPUTER APPLICATION, UNIVERSITY OF MADRAS

CERTIFICATIONS

• Microsoft Certified Professional.

070 - 229 - Designing and Implementing Databases with Microsoft® SQL Server™ 2000 Enterprise Edition.

• Microsoft Certified Application Developer.

• Microsoft Certified Technology Specialist (SQL Server 2005).

SKILLS

Web Technologies

ASP.Net 3.5/2.0/1.1, C#, VB.Net, MVC 1.0, WCF, Silverlight 2/3

Windows Tech

Win Forms, C#/ VB.Net, VB 6.0, VBA for Access

Web Servers

IIS 6.0/5.0/4.0, COM, COM+

RDBMS

SQL Server 2008/2005/2000, LINQ, Oracle 9i/10g and MS Access 2000/03/07.

ETL

SSIS (SQL Server Integration Services)

Reporting Tools

SSRS (SQL Server Reporting Services)

Scripting

JQuery, JavaScript, VBScript, AJAX

Operating Systems

MS DOS, Windows 95/98/2000/XP/Vista.

Languages

C, C++, JAVA, C#, Visual Basic, .NET, JavaScript and HTML.

Software

DBA Studio, Red Gate, TOAD, Case Studio, Erwin, and DBArtisan.

Tools

Microsoft Project, Microsoft Visio, Ultra Edit, CuteFTP, Coffee Cup HTML and Adobe Photoshop.

713-***-****  ******.*******@*****.***

Contact this candidate