OBJECTIVE

• Seeking a DBA position where I can apply and enhance my knowledge and expertise. I am quick to adapt and learn new technologies and configurations.

SUMMARY

• Experienced Senior SQL Server DBA in the area of Development, Administration, data modeling, Performance Monitoring and Tuning SQL Servers.
• Outstanding ability to manage many projects at once while working with strict deadlines.
• Proven ability to successfully streamline, optimize and maintain system functionality performance and recoverability. I have excellent diagnostic, problem - solving and team work skills.

AREAS OF EXPERTISE

• Database Administration
• Performance Tunning
• Backups/Diaster Recovery
• Change Management
• EnterpriseApplications
• High Availability/Replication
• Database Security
• Azure/AWS Cloud
• Strategic Planning
• Data Migration
• ETL
• Integration

TECHNICAL SKILLS

Databases: MS SQL Server 2016/2014/2012/2008/2005 , MS Access, Oracle SQL, MySQL.

Programming Languages: T-SQL, VB,.Net, JAVA, C, C++, C#, PowerShell.

OS Platforms: Windows 2012/2008 R2/2003/2000/Win7/XP, UNIX, Linux.

Cloud Platforms: Amazon AWS (EC2, RDS, Auto Scaling, Cloud Watch) and Azure.

Tools: SSMS, Profiler, Performance Monitor, Query Analyzer, BIDS, SSIS, SSAS, SSRS, Visual Studio.

Monitoring: SCOM, Idera, Spotlight and Foglight.

Analysis and Design Skills: Data modeling, physical database design, Data Warehouse concepts.

Networking/Protocol: TCP/IP, DNS, DHCP, WINS, LAN, VPN, HTTP, FTP, ODBC.

PROFESSIONAL EXPERIENCE

Sr. SQL Database Administrator

Confidential, Roseville, CA

Responsibilities:

• Primary and Lead DBA for WellsFargo Enterprise Data Management Group customers.
• Installed, configured SQL Server 2012/2014/2016 and applied hot fixes, cumulative updates and service packs.
• Architect and Implement HA+DR solutions, Always On Fail over Clusters and Availability groups.
• Implement and Maintain Snapshot and Transaction Replication.
• Migrated current on-premises databases to Amazon RDS SQL Server.
• Migrated Integration & Reporting Services workloads from On Premise to Azure Cloud.
• Implement Azure IaaS solutions to move SQL Workloads to Azure.
• Involved in operational support, design and development of Infrastructure systems, consultation with application teams, performance tuning and troubleshooting of SQL Server environments.
• Automated Administrative tasks using TSQL and PowerShell
• Created Servers Inventory report over Remote Server using PowerShell Script.
• Automated Backup/Restore, Database migration and Refresh with PowerShell Script.
• Troubleshooting and Resolving SQL Server locking, blocking and deadlocking issues.
• Performance Troubleshooting of Resource Bottlenecks such as CPU, Memory & IO.
• Involved in Index tuning, Query Optimization using Performance Monitor, SQL Profiler and related DMV's to improve performance.
• Quaterly perform Real-time Failover BCP Activities by using PowerShell.
• Performed capacity planning on SQL Servers to estimate the size of database.
• Coordinating with different teams during deployments like Release management, Engineering, Server management team, Change operations team etc.
• Re Architect Database Security by implementing principles of Least privileges.
• Enforce Policy based management of SQL Server Instances and Databases.
• Auditing SQL Server for Compliance using SQL Server Audit.
• Configured and monitored Transparent Data Encryption (TDE) in SQL Server
• Provided 24x7 on call support for high trasaction Production Envinorment.

Sr. SQL Server DBA

Confidential, Fresno, CA

Responsibilities:

• Primary Database Engineer for supporting Confidential Infrastructure ERP applications.
• Involved in planning and implementation of upgrading SQL Server 2005/2008R2/2012 environments.
• Configuring and Maintaining High Availability features like Always On Clustering, Log shipping, Replication, Database Mirroring and AG Groups and Multi Subnet Clusters.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Coordinated with the Business Analyst and prepared Logical and Physical Data-models as per the requirements involving multiple subject areas, domains and naming standards.
• Migrated data from different sources (text based files, Excel spreadsheets, and IBM AS/400) to SQL Server databases using Integration Services (SSIS).
• Scheduled nightly and weekly Loads/Reports by creating jobs in SQL Server Agent.
• Creating and maintaining MS SQL Server backup, restore, security, performance tuning.
• Used SQL Profiler, Performance Monitor to find out performance issues with queries.
• Designed and developed dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Implement and Maintain High Availability of Azure SQL and SQL Data Warehouse.
• Architect and Migrate On-premises SQL Instances and Databases to Azure Resource Manager VMs, Azure SQL and SQL Data warehouse.
• Create Custom Scripts leveraging the Azure Automation and Azure PowerShell to Import/Export Azure SQL and SQL Data Warehouse from and to Azure Blob Containers.
• Involved in tuning and configuration of SSIS.
• Involved in Analyzing, designing, building, & testing of OLAP cubes with SSAS.
• Created Interactive reports using SSRS.
• Resolved Production tickets generated due to failure of production jobs.
• Maintain Source Code Versions of Various Development works using Git, GitHub and TFS.
• Created documentation for all Packages and Reports.

SQL Server DBA

Confidential, San Leandro, CA

Responsibilities:

• Involved in Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
• Involved in business meetings and gathered business crucial requirements.
• Served as core member for decision makings and implementation.
• Created and maintained development, testing, staging and production database.
• Data migrations between PROD, UAT and DEV/SIT environments for high volume databases.
• Served as a core database and ETL development team.
• Created SSIS packages for data importing, cleansing and parsing.
• Extracted, cleaned and validated data from XML file into database using XML source.
• Used XML task in SSIS to retrieve XML documents.
• Developed a custom tool for Data conversion and Data cleansing ETL tools.
• Designed, developed and maintained SSIS ETL packages.
• Maintained packages and database structures in TFS.
• Developed various operational Drill-down reports using SSRS.
• Maintaining monthly scheduled Data load, Data refresh activities and maintenances jobs.
• Worked on performance issues.
• Worked in very active environment with short deadlines.

SQL Server BI Developer

Confidential

Responsibilities:

• Worked on designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.
• Worked on Re-designing of existing DTS packages to SSIS packages.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in writing C# and VB.net scripts during the design process of an SSIS Package
• Worked on Troubleshooting SSIS packages.
• Involved in planning and implementation of Unit testing for SSIS Packages.
• Improved query performance by adding covered indexes, adding file groups.
• Design, development and maintenance of reports using report services (SSRS).
• Built ad-hoc reports using SQL Server Reporting Services (SSRS).
• Created interactive reports, using the report parameters, query parameters, Filters and Expressions and generated matrix/chart reports, drill down, drill through, sub reports.
• Maintaining package and reports versions in TFS, Deploying SSIS packages files to various versions of Integration Services and report deployment to reporting servers.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Servers.
• Responsible for resolving blocking and locking issues.
• Performed Replication management and monitoring the database.

SQL Data Analyst

Confidential, San Leandro, CA

Responsibilities:

• Primary DBA for critical Production Databases Wellsfargo Wholesale Customers.
• Handling Very Large databases ranging in sizes from 500 GB to 1.3 TB.
• Upgrade databases from SQL Server 2005 to SQL server 2008 R2.
• SQL Server Consolidation by moving non-prod Instances to Virtual Environments.
• Configure and troubleshooting log shipping, mirroring topologies.
• Implemented, configured and troubleshooting Snapshot and Transactional Replication.
• Understanding High-Availability needs and Implementing Backup/Recovery Procedures.
• Production Code Deployment and handling concurrent user requests.
• Building BCP Environments and performing Real-time Failover Activities.
• Deploying custom maintenance procedures to maintain the health of large databases.
• Experience in Performance tuning Long Running Queries by analyzing query plans.
• Troubleshooting SQL Server locking, blocking and deadlocking using SQL Profiler.
• Index Tuning and Optimization using Index Related DMVs and DTW.
• Scheduling, Migrating, Deploying and Troubleshooting SSIS Packages.
• Create, Deploy and Manage Standard Business Reports using SSRS.
• Automated Administrative tasks using PowerShell and T-SQL.
• Analyzed performance issues and provide recommendations based on testing results or problems being experienced in production.
• Performing Oracle 10g/11g RAC database installation,design and administration.
• Performed refreshes between PRO, UAT and DEV environments for high volume databases using datapump and exp/imp on regular basis.
• Provided guidance to the development team on writing stored procedures and implemented the standards, guidelines and best practices for database development.
• Change request implementations via BMC remedy Pac2000 software tool.
• Provided 24x7 on call support for high trasaction Production Envinorment.

SQL DBA & BI Developer

Confidential

Responsibilities:

• Involved in the life-cycle of the project, i.e., requirements gathering, design, development, testing and maintenance of the database.
• Involved in installation and configuration of new SQL Server2005/2008R2 instances.
• Upgrade databases from SQL Server 2005 to SQL Server 2008R2.
• Created Database Objects like Tables, Stored Procedures, Views, Clustered and Non-Clustered indexes, Triggers, Rules, Defaults, User defined data types and functions.
• Performed query optimization and tuning of stored procedures and SQL Queries.
• Performed troubleshooting operations on the production servers.
• Monitored SQL Server jobs, and developed queries to perform database operations.
• Maintained data integrity and improved performance by applying proper indexing.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages and migrated DTS packages to SSIS Packages.
• Created and scheduled SQL jobs to run SSIS packages on a daily basis.
• Developing reports on SSRS on SQL Server (2008).
• Worked on RDL files and Stored Procedures to fix the errors and modifications of the reports.
• Performed production code deployment with release management process.