SQL Server DBA
Resume:
Sameer J El-Khal
Portland Oregon, 97236
**********@*****.***
OBJECTIVE
Looking for a Sr. Database Administrator position in a solid, stable, growing company where I can leverage my extensive experience providing enhanced Data Administration services. A growing company that allows me to grow, both professionally and technically. To grow into a position of advanced responsibility, using technical and life skills that I have gained. To make a difference in the future growth and success of the company. I don’t want to be just another cog in the machine but a linkage between data and the future success and growth of the company.
Sr. Database Administrator, 3/16 – 8/17, ARM Insight Portland, Oregon
As one of 2 Sr. Database administrators, my main responsibility was SQL administration, responsible for all the production databases on 9 servers (6 VMs & 3 physical) running SQL2014 in a PCI compliant environment hosted on Rackspace and 2 other databases hosted on Amazon AWS. Maintained, enhanced, and tested backup processes for disaster and data recovery. Created, maintained, and enhanced ETL data imports as needed for existing and new clients. Built out a testing and QA environment for deployment and report creation/testing. Developed and established data stewardship standards and procedures used in the development and modifications of current and future ETL processes. Developed new ETLs for populating test environment with fake & obfuscated data to allow for PCI data to be used in test environment. Built out a reporting environment using SQL Server, SSIS, SSRS and Power BI for system, executive and, external clients. Developed testing and reporting methodologies to evaluated cloud solutions in preparation of moving products to the cloud following established data stewardship standards.
Sr. Database Administrator, 3/12 – 3/16, Smarsh Inc Portland, Oregon
As one of 4 Sr. Database administrators, my main responsibility was SQL administration and infrastructure. Was responsible for all the production databases on 2 windows clusters, running SQL2008R2 and SQL2012, using replication and linked server to move data between the servers. The production databases total size was approximately 650 Terabytes, with partitioned tables and Full-text indexes. Was part of the development team that migrated the production databases from SQL2008R2 to SQL2012 with zero down time. Developed and implemented backup processes and scripts for disaster and data recovery. Developed and created a database space report showing the database file structure, available space and how it relates to the container volumes; allowing for database file and volume SAN growth projections. Responsible for maintaining 4 environments QA, Development, Dry-Run and production, keeping them in synch with production type data using backup/restore, SAN snapshots/replays. Responsible for maintaining SQL on the DR site with periodic testing of individual applications and system wide blackouts. Performed some minor SAN work, such as expanding, adding and moving volumes; Acted as backup during the SAN administrator absence.
Sr. Database Administrator, 4/11 – 2/12, Huron Healthcare Lake Oswego, Oregon
General Admin duties, Indexing/Statistics, Performance issues, Customized client DB server monitoring. Automated server checks. BizTalk Data/Disaster recovery. Troubleshooting database performance issues; indexing, statistics and maintenance automation. Provide DB support to client support teams (5 teams with over 100 installations). Assist in performance troubleshooting of client issues. Develop and deploy customized database monitoring/alerting/reporting solution to all client database servers. Documented troubleshooting framework around data imports and client system integration. Developed script to perform Server QA and validation before/after software install. Coordinated/installed database maintenance plans including a smart indexing process and a synchronized database backup maintenance plan for a BizTalk environment for data/disaster recovery
Sr. Database Administrator, 5/10 – 3/11, County of Multnomah Portland, Oregon
Perform general DBA duties on 20 SQL Servers ranging from SQL 7, 2000, 2005, 2008 and 2008R2; performance tuning, code review, backup/restore verification. Installed, configured and deployed SQL Diagnostics Manager on all production servers; OLTP, SSRS, SSAS. Lead database architect on using SAN technologies for replicating production databases to no-prod environments for data/disaster recovery. Developed install scripts for unattended SQL server install and database server SAN configuration. Lead on debugging performance issues and database patch testing and deployment. Created and presented a class to all developers on indexes. Deployed automated re-indexing process on all production servers.
Sr. DBA, 2/10 – 5/10, State of Oregon Portland, Oregon
Troubleshooting performance issues, indexing/statistics, maintenance plans, DB monitoring/alerting. Troubleshooting database performance issues; indexing, statistics and maintenance automation. Developed a database re-fresh process for a reporting database using SQL replication. Developed a number rudimentary database monitoring/alerting scripts.
Sr. Production DBA, 4/07 – 2/10, Vesta Corporation Portland Oregon
Administer and monitor database servers running Microsoft SQL Server 2005 in mission critical a high transaction 24X7 environment. Administer and monitor 5 database servers running Microsoft SQL Server 2005 in a high transaction 24X7 environment. This included 15 mission critical partner and 6 core databases in excess of 1 TB. Duties included but not limited to monitoring server and database resource usage; server and database performance (processes and procedures) using SQL Profiler and Windows System Monitor. Develop/Deploy/Monitor Data replication process to move data from OLTP to financial/BackOffice system using SQL Server replication (transactional). Administered/Audited all database permissions and access for PCI compliance. . Developed dynamic index maintenance process based on index size and usage. Planning, Deployment and Implementation of new partner databases based on relational data modeling principles and techniques. Built visual dashboard to continuously monitor database performance based on traffic volume and tune resources as needed. Plan, develop and implement an enterprise wide database backup, archiving and data recovery process; using Evault. Developed a long-range HA strategy involving; a migration of all the production databases to a 5 node cluster using SQL named instances and a SQL mirroring site fail-over for resilient disaster recovery. Installed/configured and monitored production and non-production servers including SSAS, SSIS and SSRS. Build a data warehouse to collect database server performance using SSIS, SSAS and SSRS. Performed DBA duties on development, integration and staging environment encompassing approximately 225 databases. Involved with developing database ‘Best Practices' and lead on code reviews for database stored procedures, triggers, schema changes and validating all T-SQL code for database object creation.
Database Administrator III, 3/04 – 4/07, Kronos TMD Inc. Beaverton, Oregon
Administer 27 production mission critical databases on SQL Servers 2000 installed on windows 2003 active/passive clusters. Administer 27 production mission critical databases on SQL Servers 2000 installed on windows 2003 active/passive clusters. Provided advanced DBA support for 63 non-production databases running on virtual servers. Planning, Deployment and Implementation of new partner databases. Applied relational data modeling principles and techniques on newly developed databases. Developed and implanted database monitoring and alerting jobs and processes. Monitored server performance using SQL Profiler and Windows System Monitor and provided tuning feedback to developers and systems engineers. Developed stored procedures, triggers and views according to application requirements. Developed, built and managed database replication processes using SQL Server Replication services. Developed and managed database security protocols. Developed and built a systems dashboard to monitor server performance and transaction processing and providing a "heads up" to developers, engineers and customer support of projected issues. Developed database disaster recovery plan using a combination of warm stand-by servers, transaction log storage and tape backup. Developed and tested a plan to migrate all databases from SQL Server 2000 to SQL Server 2005. Lead on code reviews for database stored procedures, triggers, schema changes and validating all T-SQL code for database object creation.
SQL Server DBA, 8/01 – 2/04, Con-Way Transportation Services Portland, Oregon
Manage 15 mission critical database servers running SQL Server 2K in 14 service centers across the US. Using SQL Server Dynamic Merge and Transactional replication. Manage 15 mission critical database servers running SQL Server 2K in 14 service centers across the US. Developed a mechanism to move shipping and shipment status info from one service center to another using SQL Server Dynamic Merge and Transactional replication. Created data transformation packages using SQL server to send and receive EDI, WEB and XML data streams into and out of SQL Server Database. Developed and implemented a disaster recovery plan for the main production database using "Log Shipping". Developed data collection process using DTS to collect sales, shipping data and populate a data warehouse created using SSAS, used Excel as a reporting tool. Lead on code reviews for database stored procedures, triggers. Reviewed newly created databases based on relational data modeling principles and techniques. Responsible for all T-SQL code generated.
Database Administrator, 4/98 – 7/01, CerikaCorp Vancouver, Washington
Administer, develop and implemented database client server applications for CerikaCorp's assigned clients. Administer, develop and implemented database client server applications for CerikaCorp's assigned clients, based on relational data modeling principles and techniques. Assigned as Lead DBA for ERP implementations and data migrations. Responsible for AS400 migration to PeopleSoft HR and Financials from initial case studies to final implementation. Created and validated all T-SQL code for object creation
Network/Database Consultant, 12/94 – 9/97, PC Support Inc. Portland OR
Install/setup/configure/administer Windows NT Servers at assigned client sites. Develop/program databases for various clients based on detailed dataflow diagrams and user specifications.
Contact this candidate