Biswa Mahapatra

***** **** ****** **

Chantilly VA 20152

Cell: 703-***-****

E-Mail: acp4or@r.postjobfree.com

SQL Server Development DBA: Eleven years of experience for major software development corporations, providing systems and web programming, analysis, and database development/administration/architecture services. Qualified to play an integral role in the field of information technology where talents and experience will contribute to achieving company goals. I’m authorized to work with my Green Card in the United States.

EDUCATION:

Masters Degree in Computer Applications, Madurai Kamraj University, INDIA.

CERTIFICATION:

Microsoft® SQL Server™ 2005/2008 Database Maintenance And Implementation

TECHNICAL SKILLS:

Database Design/Tools: CASE STUDIO 2.0, ERWIN, MS VISIO.

Database: SQL Server 2012/2008R2/2008/2005/2000, Oracle 8i/11gR2, MsAccess, DB2 9.7.

Operating Systems/Servers: Windows 2008 R2 Data Center, Windows 7/2003/2000/NT/ XP/9x, IIS 6.0, Linux RHEL 6.5

ETL Tools: SSIS/DTS,SQL Loader

Languages: VB.NET, C#, VB 6.0/5.0, ASP, SQL/ T-SQL/PL/SQL, HTML, Java Script, VB Script

XML Technologies: XML, XML Schema

Third Party Tools: Idera Tools, LitesSpeed, SQL Data Compare, SSMS Tools,TOAD.

Sourcesafe : VSS, TFS, ClearQuest, SVN.

Fannie Mae,Reston VA 10/2014 to Current

Production Support DBA/Contractor

Working with Enterprise Shared Services and responsibilities include:

Installation, configuration and capacity planning for all 15+ SQL Server 2008 R2 corporate databases in various SDLC environments

Maintaining and Supporting 24/7/365 Production mission critical Loan/Mortgage Database Servers

Analyzing change requests, troubleshooting production issues and propose LOE using BMC remedy tool.

Continuous monitoring of AWR, troubleshooting and fine tuning PL/SQL programs

Prepare documentation for Internal Data Delivery through Business Objects used in Access Management Reporting space.

Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.

Good knowledge on logical and physical Data Modeling using normalizing Techniques.

Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).

Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

Developed materialized views for data replication in distributed environments.

Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.

Loaded Data into Oracle Tables using SQL Loader.

Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

Ventera Corporation, Reston VA

Database Lead 01/2012 to 10/2014

Working on State of RI DMV Project and supporting SDLC and responsibilities include:

Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.

Involved in enhancements and maintenance of Data model using ERWIN.

Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.

Defined Policy/Standards and process for the database system and its infrastructure planning

Consolidate databases onto less servers to cut software and infrastructure costs

Conduct Daily SCRUM, team meeting with client and ensure/tracking of deliverables

Responsible for SQL Server Installation, Upgrades, scheduling maintenance plans and conducting and monitoring log shipping and database clusters.

Performing regular maintenance of databases and scheduling backups and refresh environments with data

Migrating Databases from SQL Server 2005/2008 R2 to SQL Server 2012.

Perform code review of Integration Packages and stored procedures for better optimization by following best practices.

Extensive experience in ETL for disparate data sources and their transformations into SQL server based on data entities anomalies

Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER.

Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

Maintaining consistent development, testing, staging, production and disaster recovery environments, both on physical machines and Hyper-V/VMware machines

Performed regular maintenance including index optimization, consistency checks, and data file and transaction log size monitoring using built-in tools, custom written T-SQL scripts, SQL Agent Jobs, and Database Mail using SMTP server.

Maintain partitioned 4TB databases for future data growth and optimizing storage by applying compression.

Assisting App/Dev team to follow standards, coding practice, preparing data dictionary

EDGAR Online Inc. Rockville, MD 03/2010 to 11/2011

Database Engineer/DBA(FT)

Responsibilities:

Responsible for monitoring and integration of database systems for various database environments using SDLC process

Working with CCB and stakeholders for applications to outline the impact and development of projects goals using AGILE SDLC.

Involved in logical and physical modelling for the application and created ER diagram using Erwin.

Perform day to day Database Maintenance tasks -- Clustered & Non-clustered Database Monitoring, Backups, Space Management, Resource Utilization, Controlling and monitoring user access to the database ensure data integrity.

Assisting DB team in fine tuning SQL queries by following Physical Data Modeling diagrams and data dictionary.

Checking Database Health by using DBCC Commands and DMVs

Migrating Databases from SQL Server 2005 to SQL Server 2008 R2.

Well versed with Database projects and Team Foundation Server for Version Control.

Lumenos Inc., a Well point Inc. Company, Alexandria, VA 08/2006 till 03/2010

Consultant/Database Lead

Responsibilities:

Well versed with HL7,SAS70 and HIPAA standards.

Technical lead for Real-time pharmacy claims processing team for development / deployment / and support.

Peer reviewing Stored Procedures and releasing code through SDLC environments

Installation, configuration and capacity planning with regards to Disk, Memory and Processor for all 15+ SQL Server 2005 corporate databases.

Maintaining and Supporting 24/7/365 Production and Disaster Recovery Database Servers in Clustered environment using RAID/SAN configuration.

Created and configured an OLTP replication database for streamlining real-time pharmacy claim processing.

Involved in data modelling and created ER diagram using Case Studio/ERWin.

Implemented Database partitioning for claims and members enrolled under CDHP plan.

Periodic Data Refresh/Cloning in Non-Production environments.

Troubleshoot Infrastructure issues related to SQL database server such as memory, I/O, Disk, etc. Monitor log files to proactively resolve issues.

Applied new MS SQL Server hotfixes/upgrades, releases and security patches to keep the database at current patch level.

Routinely solved critical production problems, and perform point-in-time database recoveries

Achieving business goals using AGILE methodology and SCRUM methodology.

Verizon Inc., Dallas, TX 06/2005 to 08/2006

Developer/DBA, Consultant

Responsibilities:

Participated in periodic technical reviews of various applications and developed suggestions/schema to improve over them.

Participated in daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Designed and populated reporting tables using views and stored procedures.

Troubleshooting performance issues and fine-tuning queries and stored procedures.

Extensive use of DTS packages on the SQL Server to import data arriving

from various centers/systems (POS).

Successfully converted legacy DTS packages to SSIS packages under Business Intelligence Development Studio and deployed following the ETL lifecycle.

Monitoring and optimizing system performance and long-running queries using SQL Profiler and Database Engine Tuning Advisor

Amergent Inc., Peabody, MA 07/2004 to 05/2005

SQL Database Consultant

Responsibilities:

Responsible for configuration of Microsoft Server/Client Products and implementation.

Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.

Defined relationship between tables and enforced the referential integrity constraints. Created Clustered and Non-Clustered Indexes.

Responsible for in-house Database Administration and Performance tuning using query analyzer/ SQL profiler

Used MS Visual Source Safe 6.0 as a Version Control System.

Deployed Maintenance plan for Database Integrity, Index optimization.

Contact this candidate