SUMMARY

• Lead SQL Server DBA who has been supporting database applications for over 15 years now seeking challenging opportunities in the MS SQL Server sphere of operation (I also have some Oracle and MySQL Experience).
• Responsible for troubleshooting and problem solving of SQL and MySQL database Servers.
• Experience writing, debugging, and tuning Transactional SQL, DTS and SSIS stored procedures.
• Ability to ensure the technical integrity of corporate databases by protecting against the loss or misuse of information and designing backup/recovery strategies.
• Experienced in deploying SQL server 2012 cluster solutions.
• Responsible for improvement and maintenance of the databases to include release rollout and upgrades.
• SQL Server Replication (Native and GG).
• Experience managing multiple MS SQL 2000, 2005, 2008, 2008r2, 2012, 2014, 2016 RDBMS on web - based, transactions.
• Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery in managing clusters of SQL servers.
• Experience with setup and administration of SQL Server Database Security environments using Profiles, database Privileges and Roles.
• Provide SQL Server database physical model creation and implementation (data type, indexing, and table design).
• Experience working with Snapshot, Peer-Peer and transactional replication.
• Management of multi-terabyte production clustered systems using ACTIVE-PASSIVE Clustering. Implementing and Managing ETL solutions and automating operational processes.
• Optimizing and tuning the Redshift environment, enabling queries to perform up to 100x faster for Tableau and SAS Visual Analytics
• Wrote various data normalization jobs for new data ingested into Redshift
• Advanced knowledge on Confidential Redshift and MPP database concepts.
• Migrated on premise database structure to Confidential Redshift data warehouse
• Was responsible for ETL and data validation using SQL Server Integration Services.
• Defined and deployed monitoring, metrics, and logging systems on AWS.
• Implemented Work Load Management (WML) in Redshift to prioritize basic dashboard queries over more complex longer-running adhoc queries. This allowed for a more reliable and faster reporting interface, giving sub-second query response for basic queries.
• Worked publishing interactive data visualizations dashboards, reports /workbooks on Tableau and SAS Visual Analytics.
• Responsible for Designing Logical and Physical data modelling for various data sources on Confidential Redshift
• Designed and Developed ETL jobs to extract data from Salesforce replica and load it in data mart in Redshift.
• Expert in reviewing overall physical database structure for overall stability
• Proficient in use of tools like extended events, DMVs, SQL Server profiler and Windows performance monitor.
• Experience with implementing Database Disaster Recovery and Planning (Mirroring, Log Shipping and Always-ON).
• Experienced with the design, implementation, and administration of SQL Server and Oracle database solutions.
• Have good understanding of Disk and Server configuration for SQL Server.
• Solid experience with VLDBs on High Volume transaction environments (over 22k /sec).
• Experience with network connection tuning using SQL Server 2005, 2008, 2008r2, 2012, 2014, 2016.
• Development database support (SQL, T-SQL tuning, Application tuning etc.).
• Experience using PowerShell (Windows and SQL server).
• Experience installing, configuring and managing SSIS, SSAS and SSRS.
• Experience configuring and managing SQL server on AWS RDS, EC2 and AZURE (Iaas and Paas)
• Experience with monitoring and troubleshooting 24x7 operations.
• Experience with cross-platform database migration and database instance consolidation.

AREAS OF EXPERTISE

• Data Migration Disaster Recovery Performance Tuning
• Backup and Recovery Database Security High Availability Solutions
• Database Upgrades patches Reporting Services Integration Services
• Analysis Services Goldengate Reporting Services
• Always ON In - Memory OLTP Project Management
• RedShift AWS (RDS &EC2, S3) AWS Data Pipeline

TECHNICAL SKILLS

RDBMS: SQL 2000, 2005, SQL 2008, 2008R2, 2012, 2014 and 2016 Database Administration, PowerShell, HP OpenView, HP ServiceDesk, Cherwell, Idera SQL DM, ESX, VCenter, Hyper-V, SQL Sentry, Replication, Enterprise Environments, Tuning, SQL Profiler, Clustering, Golden gate, SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services, NoSQL, MySQL, RedShift

Operating systems: Windows ME/NT/ 2000/2003/2008/2008 R2/2012/2012R2/2016/Xp/Vista/7/8/10;

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL Server Infrastructure Architect

Responsibilities:

• Serving as the technical expert (S.M.E) in SQL Server technologies.
• Participating in upgrade and migration efforts for various clients from SQL Server 2008 and 2008R2 to SQL Server 2012, 2014 and 2016 as the need arose.
• Installed and configured multiple SQL Server 2014 and 2016 Multi-Node Geo-Clusters for Mission critical production databases.
• Utilizing expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration to improve uptime as well as reduce RPO and RTO of business.
• Saves business over $300,000 in license costs by pushing the use of SQL Server 2016 Std Edition based on the application requirements and the improved HADR capabilities in the SQL release.
• Working with developers to optimize geospatial queries.
• Working with developers to improve query execution times and boost performance.
• Performing periodic database maintenance on all databases across all environments (Both legacy and current).
• Performing regular monitoring, alerting and maintenance on all HA and DR setups within the DC from Mirroring to Log Shipping to Always-ON.
• Mentoring younger DBAs in the company.
• Deploy and administer AWS Redshift, columnar data lake, and SQL query engines.
• Automate provisioning, operation, monitoring and troubleshooting of the database and data lake infrastructure.
• Provide consistent database maintenance, optimization and best practices inputs to existing Redshift and SQL databases, Data Lake, SQL engines, and applications.
• Auditing Users and analyzing schemas in RedShift.
• Utilizing Lambda data loader to automate the data load process from S3 to Redshift database.
• Implementing SQL Server best Practices for Installing, Configuring, Troubleshooting, Querying, etc. on all sql server databases across the enterprise.
• Implementing, monitoring and troubleshooting SQL Server Replication and Mirroring across all sql database servers in the enterprise.
• Utilizing experience in SharePoint to manage all SharePoint database servers.
• Providing off-hour support for all production databases on a quarterly basis (we had a large dba team).
• Participating in periodic database refresh operations for lower environments.
• Participating in root cause analysis of performance issues within the environment.
• Participating in Project and SQL Team meetings on a regular basis.
• Automating the Installation and documentation of SQL Server instances for manageability and Licensing purposes.
• Utilizing experience in various virtualization technologies to manage multiple SQL servers on Virtual appliances.
• Managing High Volume VLDB pushing over 22k tps.
• Utilizing AZURE and AWS platforms to create and maintain various SQL Server versions
• Performing other duties as assigned.

Confidential

Principal SQL Server DBA

Responsibilities:

• Served as the technical expert in SQL Server technologies.
• Served as lead for the SQL Server Production team.
• Participated in SQL Server database systems design and operations.
• Participated in software upgrades, revisions, patches, and fixes mandated by the vendor.
• Assisted in the resolution of complex problems in support of production; including on call support.
• Ensured that the detailed physical design of database and data structures comply with data policies, standards, principles, and meets the established level of service agreements/goals for the system.
• Managed the corporations, Licensing and Elections systems for the state of Georgia.
• Participated in disaster recovery strategizing for the Secretary of state’s office.
• Maintaining solid technical skills in R/DBMSs, products, utilities, protocols, and techniques.
• Managed and monitored SLAs for uptime and performance of SQL Server databases.
• Demonstrated experience in working on root cause analysis for SQL Server database issues.
• Flexible, adaptable, and able to managing multiple tasks in a dynamic environment.
• Proactively monitored the database systems to ensure secure services with minimum downtime.
• Project management for Database technical projects.
• Implemented SQL Server 2012 and 2014 Always-ON Availability Groups and Listeners for HA and DR purposes.
• Set up monitoring and alerting for SQL Server Always-ON as well as other SQL Server conditions.
• Provided on call support on a rotating basis.
• Helped manage a few opensource DBMS.
• Other duties as assigned

Confidential

Manager Database Infrastructure Architect

Responsibilities:

• Lead efforts of DBA team in stopping spiral of production environment and stabilize the database environment; leading to business continuity.
• Lead the Migration of productions clusters from underlying HP ProLiant infrastructure to CISQO UCS infrastructure to accommodate more hardware resources and improve performance of SQL Server databases.
• Revise and improve current monitoring strategies for the entire database enterprise (Introduced and setup Solarwinds and SQL Sentry).
• Standardize processes for the Infra DB team by creating documentations for installations, migrations, upgrades, backups, restores, index maintenance, etc.
• Lead the efforts of the database team in improving CPU consumption for all critical production database servers by tuning queries, databases, instances, etc. Thereby reducing the CPU workload from a steady 90% to 10% and resulting in a 300% increase in transaction processing.
• Mentoring less experienced team mates on internal IT policy changes and the technology in general.
• Revise current DR and HA strategies and improving them, thereby reducing downtime in the event of any failure.
• Determine and document stabilization roadmap for the next 5 years based on trends in technology for the company.
• Participating in on-call rotation with the team.
• Designed and participated in the effort that led to the change of our push replication (Transactional) architecture from a 2-tier to a 3-tier system.
• Maintaining all environments (prod, uat, test, training and dev).
• Serving as S.M.E in all things SQL Server for all assigned clients.
• Troubleshooting issues and carrying out root cause analysis on the issues as well as finding lasting solutions to those problems and documenting findings.
• Worked with SQL Sentry and Solarwinds to implement farm-wide monitoring and alerting for all production and UAT/QA database systems (the company was formerly using Idera’s SQL Diagnostic Manager prior to my arrival).
• Performing frequent health checks for all backups and productions (mission-critical) databases.
• Creating and analyzing daily reports for mission-critical databases.
• Establish escalation policies for the db team.
• Setting up and managing replication, mirroring and log shipping.
• Ensuring that all configurations are properly implemented and working based on the company needs (Resource Governor, Policy based management, CMS, etc).
• Saving the company over 120,000 in licensing costs for sql server by consolidating databases and instances based on specific criteria.

Confidential

Database Infrastructure Architect

Responsibilities:

• Evaluating the current infrastructure and proposing revisions.
• Building out new clusters to handle mission-critical databases.
• Revise and improve current monitoring strategies for the entire database enterprise.
• Standardize processes within the data ops department including creating documentations for installations, migrations, upgrades, backups, restores, index maintenance, etc.
• Mentoring less experienced team mates on changes and the technology in general.
• Revise current DR and HA strategies and improving them, thereby reducing downtime in the event of any failure.
• Proactively monitoring the entire instances and databases for any abnormalities.
• Troubleshooting issues and carrying out root cause analysis on the issues as well as finding lasting solutions to those problems and documenting findings.
• Participating in on-call rotation with the team.
• Maintaining all environments (prod, uat, test, training and dev).
• Performing mini health checks every morning.
• Analyzing daily reports for mission-critical databases.
• Setting up and managing replication, mirroring and log shipping.

Confidential

Lead Database Administrator (SQL Server)

Responsibilities:

• Conducted interviews and participated in hiring decisions along with HR in order to retain the best talent in the organization.
• Participated in quarterly meetings with Senior Management to discuss technical infrastructure and market recommendations assisting in the formation of the technology roadmap
• Lead database compliance effort in accordance with sas70 and iso20k and participate with internal and external audits resulting in fulfillment of FDA requirements.
• Managed technical review board (TRB) meetings ensuring that changes to production environments are validated and thoroughly tested. This effort reduced the number of outages by over 25%.
• Responsible for promoting team bonding among members of my team.
• Responsible for tracking and inspiring the career growth of team members.
• Responsible for scheduling and presiding over team meetings and making notes to senior mgmt on the progress of my team.
• Responsible for driving the consolidation and upgrade efforts of all database systems into SQL server 2012.
• Managed datacenter with over 120TB of data and set up various measures to manage the said data including; partitioning, transactional and peer to peer replication, log shipping, mirroring and clustering.
• Supporting production environments and mission critical databases on a 24/7/365 basis including on-call responsibilities.
• Upgraded client RDBMS to SQL server 2012.
• Configured and installed Windows server 2012 and SQL server 2012 clusters.
• Set up HADR for SQL server 2012 databases.
• Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code.
• Performed various data migration tasks for mission critical databases.
• Worked with a team of 6 to manage over 2000 databases ranging from 350GB to 2.3TB.
• Enhanced security control my creating user defined server roles in SQL server 2012 for clients.
• Ensured availability of instance and databases via clustering and mirroring.
• Utilized the “Partially contained database” feature of SQL server 2012 to ease migration and database refreshes for clients.
• Set up policies to guide database usage in SQL server 2008r2.
• Performed DBA duties including: database backups, restores, performance tuning, and capacity analysis
• Worked with bi team and reporting group in generating the weekly, monthly, and quarterly report by using SQL Reporting Services.
• Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity
• Designed, implemented and upgraded SQL Server 2005, 2008 and 2008r2 databases for mission-critical business
• Developed and optimized stored procedures, triggers, and SSIS packages
• Troubleshoot databases and custom application issues
• Designed the backups and recovery strategies for SQL Server databases to meet our customer SLA requirements.
• Managed entire project to which were assigned in accordance with the Service Level Agreement (SLA) and Statement of Work (SOW) to ensure all departmental related cost and expenses are keep on track with the project schedule.
• Managed the entire database environment visibility and accountable for every database decision made to upper level management.
• Was responsible for planning, implementing and documenting database structures and contents for Oracle and SQL Server databases.
• Work with end users to define, implement, and maintain their reporting requirements.
• Configured the physical design of the database by implementing a flexible Architecture compliance that suites both OLTP and Data warehouse applications.
• Configured various logical database structures such as table spaces to store application objects and rollback segments for transaction processing.
• I have successfully engaged in various DR (Disaster Recover) efforts for my customers.