Sowjanya.Talasila
ac4klg@r.postjobfree.com
SUMMARY:
Having11+ Years of Database Administration and Development experience on MS SQL SERVER 2014/2012/2008 R2/2008/2005/2000 in OLTP and OLAP environments
Experience in installing MS SQL SERVER 2014, 2012, 2008 R2, 2008, 2005 and updating with hot fix and service packs
Strong understanding of RDBMS concepts as well as Data Modeling Concepts
Extensive experience in implementing HADR solutions likeAOAG,Replication (Snapshot and Transactional), Log shipping, clustering and mirroring on physical and virtual machines
Implemented In-place and Side by SideMigration of MS SQL SERVER2005 to 2008 R2 and 2008R2 to 2012
Knowledge in writing T-SQL (DDL, DML, and DCL) statements
Migrated DTS 2000 packages to SSIS packages in 2005 using MigrationWizard
Experience using SQL SERVER 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE)
Worked on Data Integrity, Performance Tuning, Query Optimization
Providing on call support 24/7 on rotational basis for production database on mission critical systems
Implementing CR (Change Request)and CA (Change Amendments) requested by users
Performed BCP, BULK INSERT, Imported and Exported data from different Data Sources
Performed SQL Upgrades. SQL 2000 to 2005 and building SQL Clustering
Experience in analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects
Extensively used native tools like index tuning wizard, database tuning advisor, profiler, performance monitor, activity monitor, event viewer for performance analysis
Experience in Client/Server Connectivity, Database health Check, Indexing and Updating Statistics
Configured SMTP SERVER for Database Mail setup and received Alerts for the Threshold values
Worked on third party tools like BCP Remedy Tool, Lite Speed, Fog light and Red gate
Experience in creating SQL SERVER Reports using SSRS 2005/2008 and worked on Hyper-V and VMware environments
Implemented change management
24*7 Production support experience.
Performing Root Causal Analysis(RCA) of incidents and adhering to SLA standards
TECHNICAL SKILLS:
Operating System
Windows 7/Vista/XP/2000/NT, Server 2012/2008R2/2003, Exchange 2003, Linux, UNIX
RDBMS
MS SQL SERVER 2005/2008/2008R2/2012/2014, MS Access
Languages
Transact-SQL,SQL and Visual Basic
Database Tools
Enterprise Manager SQL Profiler, I-SQL, T-SQL, PL/SQL, SSIS, SSRS, SSAS, ODBC, OLTP, SQL OLEDB, ERWIN, PSSDIAG, VISIO, IIS,HP SAN SCSI, LITE SPEED, RED GATE, VSS, BMC(MAGIC Help Desk),TFS, Double Take, SQLMON, Quest Lite speed, SQL Safe, Red gate, Tivoli
ETL Tools
SSIS 2005/2008/2008 R2/2012, DTS
OLAP Tools
SSAS 2005/2008/2008 R2/2012
Reporting Tools
SSRS 2005/2008/2012, Crystal Reports, BO-Universe, WebIntelligence, MS Excel.
SAP
Lumira,HANA
Work Experience
GVR April 2017 to Present
SR. SQL Server DBA
Gilbarco Veeder-Root is the global leader of integrated technology solutions in the retail petroleum industry. From our reliable fuel dispensers to intuitive point of sale to revolutionary operation management systems and convenience store equipment, Gilbarco Veeder-Root delivers total integrated solutions from the forecourt to the convenience store. Gilbarco has the proven expertise that our customers around the world have come to depend on.
Worked as a Sr.DBAby providing support inproduction and development environments of data and implemented AOAG.
Responsibilities:
Expert in performing installation, configuration (32bit/64bit), optimization, server builds, patches, service packs, upgrading and troubleshooting of SQL Servers in Clustered and Non-Clustered Environments.
Experience in Migrating from SQL server 2000 to 2005 and 2005 to 2008 and 2008 to 2012 by using In-Place upgrade process as well as side-by-side upgrade process and documented complete Upgrade Process.
Implemented and supported different High Availability & Disaster Recovery scenarios like Always-On Availability Groups(AAG), Clustering (Active/Passive), Replication models (Transactional, Snapshot), Log Shipping (Native and Custom) and Data base Mirroring.
Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
Created effective Backup and Recovery plans by Transactional Log and Full Database Backups and utilized to recover data in 'Point in time' in case of disaster of server based on ERT(Estimated Recovery Time), RTO(Recovery Time Objective), and RPO(Recovery Point Objective) Policies.
Handled with both the Planned Failover and the Unplanned Failover
Backed up Production servers set to outside local (DR site)
Backed up SQL Servers to Local (Live site)
Ensured the systems are functioning optimally and that users are able to upload
Migrated SQL Server 2008R2 to SQL Server 2012, SQL Server 2012 to SQL Server2014
Technical Analysis, Code Review, Implementation, 24*7 production support
Worked on performance monitoring and health checks for SQL Servers
Executed SQL Server Integration Services packages using SQL Server Agent Job for building high performance data integration
Monitored, scheduled SSIS and changed SSIS Workflows & Configurations
Experienced with optimizing and performance tuning the queries for a large SQL Cube and ETL
Exposure to supporting ETL based applications
Environment: MS SQL Server 2014/2012/2008, Windows Server 2008R2/2012 T-SQL, MS Access, MS Business Intelligence Development Studio 2008.
Medtronic Apr 2015 to Mar2017
SR. SQL Server DBA
Medtronic is a medical device company headquartered in Dublin, Ireland.The operational headquarters is centered in Fridley, Minnesota, USA.Medtronic is the world's largest standalone medical technology development company.
Worked with a four member DBAteam by providing support in mission-critical production, testing and development environments of data and implemented Disaster Recovery Planning (Using Asynchronous (High -Performance) mirroring with manual failover), Testing and analyzing continuous update of documentation.
Responsibilities:
Installed and maintained of SQL Server 2014, 2012 and 2008R2 on Test, Development and Production Environments, Active Directory Administration
Build High availability, Disaster Recovery and Human T-SQL error plans to meet business requirement.
Implemented Disaster Recovery Planning (Using Asynchronous (High-Performance) mirroring with manual failover), Testing and analyzing continuous update of documentation
Created Windows Authentication Logins and SQL Server Authenticated Logins
Created database roles and application roles for security concern
Provided explicit permissions to specific tables to users in databases
Tuned stored procedures and T-SQL for performance using indexes
Prepared databases for Mirroring and Configured the principal Server
Handled with both the Planned Failover and the Unplanned Failover
Backed up Mission Critical Production servers set to outside local (DR site)
Migrated SQL Server 2008R2 to SQL Server 2012, SQL Server 2012 to SQL Server2014
Technical Analysis, Code Review, Implementation, 24*7 production support
Worked on performance monitoring and health checks for SQL Servers
Executed SQL Server Integration Services packages using SQL Server Agent Job for building high performance data integration
Environment: MS SQL Server 2014/2012/2008, Windows Server 2008R2/2012 T-SQL, MS Access, MS Business Intelligence Development Studio 2008.
Toyota Canada Inc Jan 2013 to Mar 2015
Sr.SQL Server DBA
Toyota Canada Inc. (TCI) is the exclusive distributor of Toyota, Lexus and Scion cars and trucks in Canada. Founded in 1964, Toyota has sold more than 4 million vehicles in Canada through a national network of 285 Toyota, Lexus and Scion dealerships. TCI’s head office is located in Toronto, Ontario, with regional offices in Vancouver, Calgary, Montreal and Halifax and parts distribution centers in Toronto and Vancouver.
Responsibilities:
Provided database design support for new system development; set SQL standards for object names and usage.
Developed complex T-SQL code for data retrieval.
Responsible for backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
Responsible for data retrieval by extensive use of joins normalization and views.
Responsible for developing processes automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.
Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.
Involved in Performance tuning, query-inventory, analysis and optimization.
Created and managed database users, login Ids and security.
Performed Data transfer (Import & Export) using DTS packages.
Responsible for performing complete back-up and restoration, database maintenance
Service pack updates on server and client.
Created crystal reports and hosting it in the web for the users.
Environment: Windows 2012, SQL Server 2012,Crystal Reports.
Conoco Phillips August 2011 to Dec 2012
SQL Server DBA
GE Transportation, formerly known as GE Rail, is a division of General Electric. The organization manufactures equipment for the railroad, marine, mining, drilling and energy generation industries. Was responsible for supplying the real-time data from our main office in Chicago to the other sites in Hong Kong and Beijing for sales team by peer to peer transactional replication. I was also responsible for improving the performance of our reporting process.
Responsibilities:
Installed MS SQL Server 2008, Performed Database Design and created User Databases
Excellent knowledge in Recovering Databases in emergency/data file missing/log space full
Scheduled backups and performed restore operations for system test data depending on developers' requirement
Created maintenance plan and SQL server jobs and scheduling them, setting emails alerts on failure.
Set up Peer to Peer Transactional Replication (international) along the datacenters in Europe, Asia and America.
Synched all the databases participating in PTP replication prior to setup.
Acquired Replication Accounts (including login names and permissions)
Configured Distributor on all Nodes and Publisher and tested live transaction flow
Configured Transaction replication (domestic) for reporting purpose
Created SSIS Packages to upload test data from Text files.
Used DBCC checks and fixed data corruption in Application database
Administered MS SQL Servers by creating User logins and assigned them proper permissions, observing all process running on the server making sure server will run at its best.
Responsible for Stored Procedures optimization, Performance tuning & index tuning.
Environment: MS SQL Server 2008, 2008R2 and 2012, Windows 2008R2 Advanced Server
Baxter Oct 2010 to Jun 2011
SQL Server DBA
Our global presence, strong portfolio, and near-term pipeline all serve as long-term sources of growth for Baxter as a focused medical products company. What hasn't changed is our unwavering commitment to saving and sustaining lives. Millions of patients and healthcare professionals rely on Baxter every day. Our products are essential building blocks of care and in delivering cost-effective healthcare solutions.
Responsibilities:
Administrated and supported on large number of SQL Server instances in multiple data centers including Production, Test and Development Environment.
Supported 24*7 for production systems
Managed logins and user accounts, including assigning database object permissions and ancillary privileges
Migrated databases and configured database Recovery if necessary
Performed backups and restores on large-scale SQL Server databases
Implemented Log shipping on a few databases for off site reporting purpose
Moved the Log Shipping secondary databases to different drive due to disk space issue
Provided explicit permissions to specify tables to users in databases
Moved the Log Shipping secondary databases to different drive due to disk space issue.
Performed redirected restores of databases to Test, QA and development system
Supported and Clearing the database logs everyday
Performed monitoring and tuning T-SQL and database engines
Developed all the required stored procedures, user defined functions, and triggers using T-SQL
Maintained documents and implement Disaster recovery models
Built scheduled-jobs to migrate data from flat files to database
Environment: SQL Server 2008R2, Windows 2003 Advanced Server,SQL Profiler.
Bank of Oklahoma Tulsa, OK Nov 2008 to Sep 2010
Jr.SQL Server DBA
Bank of Oklahoma is financial services holding company in the West South Central region of the United States with more than 4700 employees and operations in ten states. BOK Financials holdings include BOKF, NA, BOSC, Inc. and the Milestone Group. BOKF, NA operates TransFund, Cavanal Hill Investment Management, MBM Advisors and seven banking divisions: Bank of Albuquerque, Bank of Arizona, Bank of Arkansas, Bank of Kansas City, Bank of Oklahoma, Bank of Texas and Colorado State Bank and Trust. BOKF, NA has full-service banks located in eight states offers consumer, mortgage, and commercial financial products
Responsibilities:
Administration and support on large number of SQL Server instances in multiple data centers including Production, Validation, QA, Staging, Test and Development Environment.
Installed MS SQL Server Performed Database Design and created User Databases
Worked mostly on Windows servers
Centralized the environment by fixing the issues with their necessary maintenance plans and service accounts.
Worked with Application System Managers directly and provide suggestions under database side
Involved in Planning/Implementation/Support for database migration from SQL Server 2005 to SQl Server 2008R2
Implemented Mirroring for critical operational databases to provide no data loss
Successful in implementing and setting up the replication (Snapshot/Transactional/Merge/Peer-Peer)
Implemented Log shipping by placing the secondary database in Read-only mode.
Configured and Implemented Active/Passive and Active/Active clustering for large size databases
Performed Monitoring with SQL Profiler and Windows System Monitor
Moved System databases to different drives for data security and availability
Available production support for 24*7 whenever required
Environment: SQL Server 2005/2008 R2, T-SQL, EXCEL, Power point, Windows 2008 Server, Visual Source Sate 6.0, ITSM, Foglight, Scom, Net App Snap manager, DB Monitoring Software Imperva
Bristol Myers Squibb Nov 2006 to Oct 2008
SQL Server Developer/DBA
BMS is a global pharmaceutical company with offices, research and development labs, manufacturing plants and distribution facilities located in almost every country around the world. The project was for the Sales department of BMS. Reports are created to provide Sales analysts with “Trend analysis” and “Benchmark with competitors” related data.
Responsibilities:
Developed backup restore scripts for MS SQL Server as needed.
Upgraded to latest version from MS SQL server 2000 to 2005.
Planned, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
Created Database Objects – Tables, Indexes, Views, Triggers and Constraints.
Wrote various stored procedures for the purpose of application development.
Tuned SQL statements using Indexes and Stored Procedures.
Responsible for Disaster recovery and database maintenance plan.
Designed and implemented data access stored procedures and automating tasks.
Performed Job scheduling and alerts.
Optimized queries and performances using varies MS SQL Server tools such as SQL Profiler, SQL Performance Monitor, Execution plan and Index tuning wizard.
Created many complex Stored Procedures and used them in Crystal Reports directly to generate reports on the fly.
Created crystal reports and hosting it in the web for the users.
Environment: SQL Server 2000/2005 Enterprise Manager, SQL Query Analyzer, SQL Profiler, SSIS, MS ACCESS, Crystal Reports.