Sql Server Security

Location:

Athens, GA

Posted:

November 29, 2016

Contact this candidate

Resume:

OSEZUA JEREMIAH

+1-678-***-****

**********@*****.**.**

**********@*****.***

Athens, GA.

Technical Skills Summary:

• Over Six years' experience in SQL Database Administration, System Analysis and Design, Development & Support of MS SQL Server 2000, 2005, 2008, 2008R2, 2012 and in Production, Development & VMware Environments.

• Experience in MS SQL Server installation, configuration, performance tuning, client/server connectivity, query optimization, backup/recovery, running DBCC Commands.

• Experience in SQL Server performance monitoring, through Profiler, and performance monitor - Analyzing the performance of queries.

• Experience in Performance Tuning, Query Optimization, Database consistency checks using DBCC Utilities, Database Tuning Advisor, Hardware I/O Operations, Recompiling Stored Procedures and Index Maintenance.

• Devised data models with ER/Studio, and tuned queries and designs and implements backups and restore database policies.

• Experience in implementing many types of High availability and Disaster Recovery solutions like Clustering, Database Mirroring, Cold Standby, Warm Standby, Log Shipping, and Replication.

• Setup, Reconfigure, and Monitor log shipping of production databases and also carried out role changes, role reversals, and positioning the monitor server

• Performed physical database analysis and feasibility requirements. This involves performance, security, archival, maintenance and recovery requirements.

• Experience working with Production (24 x 7) and Development environments

• Created Database users, controlling access to SQL Server and making sure right people get access to right data and looking after security issues.

• Excellent interpersonal, analytical and communication skills. Hardware:

Microsoft Server’s Enterprise and Express Edition, Cisco Routers, Cisco Switches, Cisco ASA Firewall.

Software: SQL Server 2008, 2008R2, 2012, 2014, C++, Object Oriented Programming... The TechEdge Group August 2014 - Present

Principal SQL Server DBA

Lead a team of 4 DBAs supporting client and in-house database systems (SQL Server and MySQL) on various infrastructure projects improving service level agreements by reducing time to deliver database solutions to business.

• 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 management on the progress of my team.

• 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.

• Finally, Presale role on Microsoft packages like SharePoint, Severs, Office etc. With Value targets running into thousands of dollars in a calendar year. Pierscon Group

Database Engineer October 2012 – October 2014

• 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.

• Monitoring Transactional Replication and trouble shooting in necessary conditions.

• Updating Service packs and Security patches for the Servers.

• Testing the Data Backup by restoring as test database in a test server.

• Performance Tuning - Tune, analyze and optimize costly queries to reduce logical disk I/O for effective performance.

• Monitoring of server performance by profiler during peak periods of server utilization.

• Create and re-evaluate Indexes and made needed modifications for better performance.

• Scripting stored procedures and creating DTS packages for varied purposes as and when required in the project.

• Creating and Reviewing Security features for all the servers.

• Documentation of Server Builds specifications and Security features. Participating in process, application and database audits.

• Perform proactive maintenance of all mission critical databases (small and large).

• Coordinates physical changes and performance monitoring of two replicated production servers, one development and the other reporting server, all Microsoft SQL Server 2005.

• Showed the developers how to use and take advantage of the SQL Server Index Tuning Wizard and the SQL Server profiler.

• Configure as well as test backup recovery of database instance.

• Maintained the proper use of storage space requirements as well as adding new storage space (disk drives)

Business Connexion

SQL Server DBA November 2009 – November 2011

• Presale role on Microsoft packages like SharePoint, Severs, Office etc. With Value targets running into thousands of dollars in a calendar year.