Devi Pushpavel 804-***-**** ac3ebx@r.postjobfree.com

SQL Server DBA

Experienced and passionate Database Administrator with over 7 years of experience as a Production and Development DBA with experience designing, coding, testing, and supporting next generation database solutions in MS SQL Server, MongoDB and NoSQL environments. Proficient in assortment of technologies including WebSphere Application Server 5.x/6.x/7.0/8.x, JBoss, IBM HTTP Server, IIS, Apache Tomcat, WebSphere MQ, AWS-EC2, S3, EBS, ELB, VPC, SG and Python.

TECHNICAL SUMMARY

Very good experience in Installation, configuration and maintenance of SQL Server databases.

Excellent experience in installing, configuring, administrating and troubleshooting IBM WebSphere Application Server 5.x/6.x/7/8.x on various platforms like Linux, AIX, Solaris and Windows 2000/2003/ 2008.

Experience in MS SQL Server upgrades from 2000 to 2005.

Very good experience in design and support of cloud technologies like AWS

Worked closely with developers to define and configure Database and Application Servers, Virtual Host, Web Resources, JDBC drivers and deployed the applications across multiple instances of WebSphere.

Very good Database programming skills in T-SQL.

Experience in query optimization & performance tuning, used SQL profiler, execution plan, performance monitor and dbcc commands.

Worked in OLTP and OLAP environment that includes 24X7 support of production, QA and Development SQL Servers.

Very good experience in ETL cycle including data analysis, design, mapping and conversion of data loads.

Troubleshooting various problems in different stages of development by analyzing the logs.

Very good experience in Database backup and recovery procedures, conducting disaster recovery procedures.

Worked with other infrastructure support teams like Network & application teams whenever required

Experience in configuring and administering Connection pools for JDBC connections.

Experience in new cloud technologies like AWS, Ansible, Mongo DB, and Docker.

Designed, Developed Applications using programing languages Java, Python, shell scripts

Experience in using IIS and the innovative exploitation of its extensions.

Worked in Agile technology to support Continuous delivery.

Ability to work in a fast paced agile environment, very good team player and work independently with little supervision.

EDUCATION

Master of Computer Applications (MCA), Periyar University, India

CERTFICATIONS

Microsoft Certified Solutions Associate (MCSA) MS SQL Server 2012/2014

Microsoft Certified Professional (MCP)

IBM Websphere Interchange Server v4.3 Deployment and Toolset

IBM Websphere Application Server Administrator 8.5.5 with Liberty profile

TECHNICAL SKILLS

Operating Systems: IBM AIX 4/5/6, RedHat Linux 5/6/7, OEL 4/5/6/7, Sun Solaris, Win 200x.

Databases: MS SQL Server 05-12, DB2 7-8, Oracle 8-12c and MongoDB 3

Database Tools: Toad, SQL plus, T-SQL, DTS

Development Tools: Visual Basic 6.0, Eclipse, JavaScript, HTML, CSS, Visual Studio 2005, Docker

Programing: SQL, Java, Python, C, C++, Korn Shell Script

Middleware: Apache Tomcat, WebSphere 5.x/6.x/7/8.x, JBoss, WBIMB/WMQ/ICS

Cloud: Amazon Web Services (AWS)

EXPERIENCE

Sep 2015 – Oct 2017: Database Administrator, BITS Inc., Glen Allen, VA

Environment: SQL Server 2008/2012, Mongo DB, AWS - CLI, Cloud formation template, VPC, EC2, EBS, ELB, RDS, S3, Cloud Watch, Windows Enterprise Server 2012, .NET,SSIS, Microsoft Reporting Services. Windows 2000, Transact-SQL, Ansible, Python, GitHub, Nagios

Responsibilities:

Installs, configures and administers new third party vendor database and application program products; designs, sizes and installs tables within the context of the database and platform on which it operates.

Insures and maintains data integrity through queries and scripting with backup, archive and recovery processes; conducts or coordinates data cleanup efforts; troubleshoot technical problems related to the delivered software applications.

Responsible for monitoring and making recommendations for performance improvement in databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Created EC2 instances for hosting Mongo Instances as AWS do not have managed services.

Created cloud formation template to build large stack of application.

Resolved logins issues using Active Directory, application issues, hardware and software analysis, network connectivity problems and participated in customer feedback to improve standard tasks.

Setup CloudWatch alarm to check EC2 instance status and also EBS volume alerts to check the I/O performance.

Uploaded the binaries on S3 bucket and setup bucket policies for various AWS users.

Implemented cloud watch alarm to monitor the behavior of ec2 instances.

Aided developers with troubleshooting performance issues and helping end users with daily problems using a HP Service desk ticketing system.

Continuously working with the development team throughout the development lifecycle to identify the challenges being faced by them to meet the business and technical needs with respect to databases and provide solutions.

Analyzed Database Workload on an Amazon RDS DB Instance with SQL Server Tuning Advisor.

Proactively monitoring the Servers for job failures, server alerts and log threshold/warning alerts by setting up of Alerting Mechanism using SQL Tokens and SMTP without the use of SQL Mail.

Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).

Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.

Use of Index Tuning Wizard for indexing the tables as per profiler and execution plan evaluation

Capacity planning for space with regards the database and backup storage. Alerting for potential space issues through automated SQL scripts.

Experienced in developing Data Transformation services (DTS) packages and an Extract Transform Load (ETL) tool of SQL Server for import and export operations and implementing the business logic for loading data into OLAP databases.

Deployment of SQL Server in multi-AZ on AWS.

Created RDS instance for SQL server and migrated on-premises data from data center to AWS using import utility.

Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.

Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.

Implemented database alerting to notify application team when they have an issue with mongo cluster.

Provided excellent DBA, SME and Technical support for all SQL Server applications.

Took ownership for the database related needs and analyzed the requirements, by finding out the expected transaction per second, memory usage, CPU utilization and storage needs and delivered the database related components in record time.

Worked in Agile software development environment, responsible ensuring data security, data integrity, and scalability, providing disaster recovery, high availability, provided daily update to scrum master.

Setup of Automated Jobs for maintenance activities such as Backups, monitor logs, blocking, log thresholds, system errors, and index rebuilds CPU and memory activity and more for the SQL Server through customized SQL Scripts.

Administration of SQL Server security by creating logins, assigning roles and permissions as per requirement.

Performed numerous Mongo DB cluster setup successfully without impacting the project deadlines.

Jul 2006 – May 2008: Sr. Software Engineer, Wipro Technologies, Bangalore.

Environment: Windows 2000, SQL Server 2000/2005/2008, HTML, CSS, JavaScript, Visual Studio 2005, Visual SourceSafe 6.0, VB 6.0, IIS, COM+, Transact-SQL, XML, WebSphere MQ v6.0.1, WAS v5, WBIMB/WMQ, Apache Tomcat, Oracle 10g, BigBrother, WBI adapters

Responsibilities:

Software installation and configuring of SQL servers and backup with commvault.

Customer support, 24/7 site monitoring and troubleshooting

Reduced the overall ETL Time by SQL Query Performance Tuning. Discussed with User Interface and External Interface teams over the performance issues and provided solutions.

Database design and creation of hundreds of tables, indexes, views, and stored procedures

Performance monitoring and tuning of database and stored procedures

SQL Server 2008 database development using T-SQL programming, queries, Stored Procedures, Views.

Design Database and schema, total product development lifecycle

Worked on Extracting, Transforming and Loading (ETL) process to load data from Excel, Flat file to MS SQL Server.

Created SSIS packages to load the data from Text File to staging server and then from staging server to different environments.

Responsible for disaster recovery planning for SQL Server databases. Implemented database replication for continuous availability of production databases.

Implemented ETL using SQL Server Integration Services (SSIS), applied business logic and data cleansing in staging server to maintain child and parent relationship.

Created Backups for databases and automated the process. Executed DBCC commands like CHECKDB before backing up the databases

Experience in building SSIS packages using different types of tasks, with error handling process, Log particular event by event logging and worked on package configuration to run packages on multiple server.

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

Supported large environment having more than 400 SQL Servers with 200+ applications hosted.

Good experience in Extracting, Transforming and Loading using SSIS, Bulk Insert, BCP, DTS Packages and SSIS packages.

Performed OLAP optimization in data warehouse by rebuilding the fragmented indexes.

Worked on deploying Cubes in SQL server management studio as well as created partition on that having process full for fact table and process update for dimension daily basis.

Performed regular backups of the deployed applications.

Created Transactional Replication, Pull Subscription and defined editions to transfer data from branch to head office and vice versa.

Created stored procedures, views, tables, triggers, table-valued, scalar functions etc. on various databases for critical data involving profit and loss, net revenue, forecasting.

Created and integrated user defined functions and stored procedures for reporting purposes.

Designed and developed various complex reports.

Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.

Designed dimension modeling for data warehouse using star schema. Developed data warehouse for OLAP analysis and identified measures and dimensions according to specific requirements.

Fixed issues in the existing crystal reports.

Planning, Configuration and Monitoring of Log shipping. Performed Role Reversal of Primary and Secondary servers of the log shipped database.

Created Indexes and involved in Performance tuning.

Using DTS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.

Created DTS Package to transfer data from the Oracle source database.

Scheduled the ETL Process using Jobs and Created Alerts to notify the status of the process.

As a Production support person, monitored every day’s ETL Process, and fixed the data issues.

Modified DTS to SSIS packages to accomplish critical business logic.

Dec 2004 – Jun 2006: Software Consultant, Cnetric Enterprise Solutions, Bangalore, India.

Environment: MS SQL Server 2000, T-SQL, DTS, WBI-ICS v4.3, MQ Series v5.3, SAP, JDBC, JText, JBoss, Apache Tomcat and MQ Adapters

Responsibilities

Developed business process and analyzed the requirements.

Involved in installation and configuration of SQL Server 2000.

Applied patches and service packs to keep the SQL Server and windows software up to date.

Worked on WBI implementation methodology with ICS as the middleware.

Created database objects like Table, Views, Stored procedures, Triggers, user defined data types and functions.

Created Deployment manager and Application server profiles for both stand-alone and managed nodes.

Implemented HORIZONTAL and VERTICAL cluster for work load management.

Designed and implemented the logical and physical schema layout using Erwin.

Responsible for configuration of Microsoft Server/Client products and implementation of connection pool.

Developed SQL scripts for performing database administration.

Performed PROD - DR Failover activities.

Created DTS packages to perform data transfer from one database to another.

Developed various T-SQL stored procedures and functions for the Application.

Performance tuning and query optimization using Enterprise manager, Query analyzer, and SQL Server profilers.

Installation, configuration and administration of Websphere Application Server V6.0 on AIX.

Feb 2003 – Nov 2004: Software Programmer / Junior DBA, GoodWell Technologies, Bangalore, India.

Environment: MS SQL Server 2000, Oracle 8i, Visual basic v6.0, MS-Access, Erwin, T-SQL, DTS

Responsibilities

Development of the ER Diagram and Preparation of the Process Specifications using Erwin.

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

Responsible for General Database Administration, Query Performance tuning.

Export & Import of Databases from one server / schema to another server / schema.

Written windows batch scripts for automated backup, analyzing objects, rebuilding indexes.

Wrote procedures, functions and database triggers using PL/SQL database level.

Data modeling for new enhancements.

Deployed SQL Server database and performed ETL load.

Database Audit preparation.

Designed Database and installed the SQL server on Windows and configured the clients.

Developed the data model for web application and for various reports

Wrote the procedures, functions, packages and triggers for online purchase, redemption functionality.

Database Stress test preparation, documenting the test results.

Reviewed project request for scope, timeline for deployment, resources and priority

Provided projections for hardware/software requirements and professional resources

Planned and implemented security auditing policies and procedures for all database activity

Worked with account services, release management staff and data center staff to insure availability of the application and database

Contact this candidate