We provide IT Staff Augmentation Services!

Sr. Sql Server Developer / Dba / Bi Developer. Resume

2.00/5 (Submit Your Rating)

NY

SUMMARY

  • Over Seven years of IT experience in BI Development, Application Development, Application Database Administrator, Design, Security and Support of MS SQL Server 2012, 2008 R2, 2008, 2005, 2000 in Production, Staging, Test, Development & Cluster Server Environments .
  • Experience in Database administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database designing and Query optimization.
  • Experience wif SQL Server 2012, 2008 R2, 2008, 2005 Database Mirroring, Migration, Upgrading.
  • Overall database design, such as creating normalized databases, security, query tuning, assigning proper indexes, creating stored procedures, functions, triggers and data types.
  • Extensive experience in Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures.
  • Data migration using ETL tools like DTS services/SQL Server Integration Services (SSIS) across different databases like Oracle, Sybase & Excel files including SQL Servers.
  • Extensive experience in SQL Server reporting Services (SSRS) 2008, 2005.
  • Experience in configuring and managing Linked Servers, data transfer between SQL Server (different versions) and other heterogeneous relational databases such as Oracle and Sybase.
  • Documented Disaster Recovery plans and participated in disaster recovery drills.
  • Experience in using Microsoft’s in built tools like SQL Profiler, Windows Perfmon and DTS, SSIS, SSRS for Monitoring, Developing and Tuning MS SQL Server applications.
  • Experience in creating packages, Jobs, Sending Alerts and notifications using SQL Mail and Database Mail.
  • Extensive noledge in Tuning SQL queries & improving the performance of the Database.
  • Experience in using data modeling tools like SQL Diagrams, Erwin and Visio.
  • Creation and maintenance of Databases, creating Roles, schema and managing user permissions.
  • Experience in supporting critical Databases, Troubleshooting and documenting root cause analysis.
  • Hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T - SQL, SQL.
  • Conversant wif all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
  • Experience working wif Window 2008, 2003 Enterprise Server and Windows 2000 Advanced Server Administration and Installation.
  • Monitoring Event viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
  • Monitoring Dashboard Reports for Performance Tuning and finding bottleneck in database.
  • Worked wif Third Party tools like Galaxy for backup’s and NetIQ for database monitoring alerts and SiteScope for Server monitoring Alerts for MS SQL Server.
  • Ability to adapt new technologies.
  • Flexible, enthusiastic and project oriented team player wif solid communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS

Languages: T-SQL, PL-SQL

RDBMS: MS SQL Server 2012, 2008 R2, 2008, 2005, 2000, ORACLE9i, Sybase

Version Control Tools: Visual Source Safe, IBM Rational Clear Case, SVN

Web Server Technologies: IIS 5.1/6.0/7.0

Reporting Tools: Microsoft Reporting services 2005/2008.

Modeling Tool: ERWIN 7.0/7.2, MSSQL Database Diagrams

Operating Systems: Windows 2003/2008 R2, Windows XP, Windows Vista, Windows 7.

Other Tools: NetIQ (For Alerts), SiteScope (For Alerts). Commvault Galaxy (For Backup).

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. SQL Server Developer / DBA / BI Developer.

Responsibilities:

  • Support eBay Link, existing custom built database application.
  • Wrote extremely complex procedures to generate product titles to match Google SEO (Search Engine Optimization) standards.
  • Tuned extremely complex procedures used in UI searches (like Google search). Performance tune complex queries, procedure and suggest indexing strategies.
  • Process monthly catalog data (1 TB) and generate feeds to eBay.
  • Redeveloped all legacy feeds using SQL Data Tools / SQL Server Integration Services (SSIS) to generate newly formatted data wif better error handling using MS SQL Server 2008 R2 and SQL Server 2012.
  • Designed new optimized ETL processes to process huge datasets by implementing multi threaded parallel processing.
  • Developed stored procedures, views, and functions for UI and for ETL Processes and built new reconciliation reports as per business requirement.
  • Written optimized dynamic SQL on extremely huge datasets for better performance.
  • Designed new databases, new tables, new work flow processes.
  • Improved database performance by implementing database and table Partitioning, proper indexing on database objects (views and tables).
  • Performed data conversion for catalog and inventory data as per new industry standards (ACES).
  • Process and monitor daily inventory feeds from sellers.
  • Extensively used Profiler to understand application functionality.
  • Pulled data across multiple sources and servers running on SQL Server 2005/2008 R2, 2012.
  • Performed frequent code reviews on SQL objects, Database modeling and optimization.
  • Setup rules for database design, database development, SSIS development and SQL Jobs.
  • Prepare documentation for new functionality developed, Data dictionary, metadata and workflow processes.

Environment: SQL Server 2012, 2008 R2, 2005, Windows Server 2008, 2003.

Confidential, NY

Application DBA & Developer (SQL Server)

Responsibilities:

  • Upgrade database from SQL Server 2000 to SQL Server 2008 R2, Identify and re-write all objects not compatible wif new version of SQL Server.
  • Analyze and understand Legacy application functionality and rewrite and rebuild these applications from scratch using Microsoft SQL Server 2008 R2. dis includes designing Logical and physical data models, designing workflows, building application objects in databases.
  • Setup database security for application accounts for newly designed application running on SQL Server databases (SQL Server 2000, 2008, 2008 R2 versions).
  • Analyze and upgrade existing DTS packages to SSIS Packages for SQL Server 2008 R2 version.
  • Analyze and upgrade existing SQL Jobs create new SQL Jobs to automate manual procedures and setup proper notifications and error handling mechanism wifin the SQL Jobs.
  • Design and develop new SSRS Reports in multi domain (Non Trusted Domains) environment on SQL Server Reporting Services 2008 R2.
  • Performance tune slow running queries from Stored Procedures, Views, DTS Packages, and SQL Jobs and SSRS reports.
  • Design and develop workflows across multiple systems in multi domain environments using ETL Tools like SQL Server Integration Services.
  • For newly built applications, create new SQL Server objects (Tables, Triggers, Stored Procedures, Views, functions) on databases as per business logic from scratch.
  • Maintain version control and document all new development and enhancements.
  • Work wif admin team to setup data loading SQL Jobs between non trusted domains.
  • Perform Data Migration between legacy application and newly build application using SQL Server Integration Services wif all reconciliation reports to proof successful Data Migration.
  • Provide production support for existing application wif SQL Server 2000 and SQL Server 2008 R2 databases.

Environment: SQL Server 2008 R2, 2008, 2000, Windows Server 2008, 2003, 2000, .NET 4.0, IIS-7, SVN

Confidential, Washington DC, DC

SQL Server Application DBA and Developer

Responsibilities:

  • Confidential is the largest multilateral source of loan and equity financing for private sector projects in the developing world. It promotes sustainable private sector development primarily by:1. Financing private sector projects and companies located in the developing world.
  • Apply latest Service Packs, Cumulative packs, and all Security Patches for SQL Server 2000 and SQL Server 2005.
  • Design and manage database level and server level security for all database servers.
  • Design prototype before delivering actual BEM (Business Event Manager).
  • Design database, design table structure and apply normalization strategies, design logical and physical model for Stage database. dis stage database is where we has control to create objects, since Investran is a COTS Product.
  • Create schema, Tables, other database objects and implement data integrity through, Keys, constraints, triggers and functions.
  • Create complex Procedures, Views, functions, DML triggers and DDL triggers to implement business logic.
  • Create procedures that serve as templates for creating other objects (Tables, views, sp’s).
  • Design and create complex processes to push and pull data to other systems.
  • Design and create jobs that run daily, weekly and Monthly processes.
  • Setup high end Alerting for all processes jobs and schedules.
  • Implemented Database Mirroring between Production and DR, and Log Shipping between Development, Testing Environments.
  • Performance tune and optimize procedures and queries.
  • Worked wif SQL Server Profiler to generate traces.
  • Set up Active/Passive clustering wif multi node environment
  • Schedule Backup's, Alerts and notifications through Galaxy Backup Tool.
  • Use Third Party tools Like NetIQ and Sitescope to set up Alerts for database and server health check.
  • Set up Auditing for all OLTP Databases.
  • Worked on other short modules wif Investran COTS Product for
  • Implementation of Derivatives
  • Implementation of Funds

Confidential

Developer and Application DBA

Responsibilities:

  • Install and configure SQL Server (2005, SP2) on 32 bit and 64 bit processor machines.
  • Apply latest Service Packs, Cumulative packs, and all Security Patches for SQL Server 2000 and SQL Server 2005.
  • Design and manage database level and server level security for all database servers.
  • Install different RDBMS client tools on servers and create ODBC Connections on servers to connect to other RDBMS to pull data.
  • Design staging database from scratch for data massaging. Create logical and physical models.
  • Pull data from different sources (ORACLE, SYBASE) and load data into SQL Server in a staging database using DTS Package.
  • Build Validations, reconciliation and error handling for all DTS Packages.
  • Design and schedule complex DTS Package (32 bit utility) on 64 bit processor machines.
  • Understand business requirements and understand schema for existing applications and relationship between all entities and write SQL and PL-SQL scripts to pull data from different sources.
  • Write complex stored procedures for performing data massaging for over a million transactions using T-SQL.
  • Understand Investran Product, understand schema structure and create procedures for loading massaged data from stage database into Investran database.
  • Write complex SQL procedures to load data virtually before actually loading into the actual tables. So, data was first loaded in local temp tables, after all recons on data are performed then data was loaded in actual tables.
  • Write complex SQL Scripts used in DTS Packages for generating and exporting data for reconciliation for each conversion run. Reconciliations were done for virtual data loading (loading data in temp tables) and actual loading (loading in actual tables from COTS product).
  • Prepare documentation for each task performed and update documents as needed.
  • Maintain all scripts in VSS for version control.
  • Write SQL procedures and develop SSRS Reports for historical conversion run to show all recon reports.

Confidential

DBA

Responsibilities:

  • Install and configure SQL Server (2005, SP2) on 32 bit and 64 bit processor machines.
  • Apply latest Service Packs, Cumulative packs, and all Security Patches for SQL Server 2000 and SQL Server 2005.
  • Build Scripts for Archiving Historical Data for many COTS products in efficient way in accordance wif Industry Standards
  • Build Scripts for Daily, Weekly, Monthly DBA maintenance activities and create jobs for regular maintenance.
  • Maintain VMware, Blackberry, Notes and NetIQ databases.
  • Manage user accounts and security for all database users.
  • Do complete assessment, recommendation and implementation for infrastructure servers.

Environment: SQL Server 2005, Windows Server 2003, Windows Server 2008, .NET 3.5, IIS-7.

Confidential, LasCruses NM

Webpage designer

Responsibilities:

  • Design, creates, update and modifiy department's existing web page content, graphic design/layout and code.
  • Responsible for ensuring that the website operates as expected.
  • Maintains consistency of website.
  • Ensure hyperlinks pointing to other webpages are current.
  • Provide service in responding to questions/requests/complaints from users.
  • Update marquee messages
  • Assist in the design of marketing materials, fliers, brochures, and apparel, etc.

Environment: Dream Weaver 8.0, Front Page, Flash, Photoshop 6.0.

We'd love your feedback!