We provide IT Staff Augmentation Services!

Consultant Sql Server Dba Resume

Atlanta, GA

SUMMARY:

  • Experience debugging, and tuning Transactional SQLand 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
  • Responsible for troubleshooting and problem solving of SQL Server with RCA
  • Responsible for improvement and maintenance of the databases to include release rollout and upgrades
  • Experience managing multiple MS SQL RDBMS on web - based transactions.
  • Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery and managing clusters of SQL servers
  • Maintenance and tuning of databases and replication
  • Experience with setup and administration of SQL Server Database Security environments using database Privileges and Roles
  • Provide SQL Server database physical model creation and implementation (data type, indexing, table design)
  • Third party tools worked with includes but not limited to: Redgate, Quest Litespeed, Idera, SQL Toad, MOM, BMC Remedy
  • A dis ci pli n ed F inanc ia l/Inve stm en t /Business Ana ly st, Equ ity an d F ix e d Inco m e S ecur itie s trade r(w ith ex p e rie n c e in Priva te e qu ity, In ve stm e nt ban k i ng, Co rpo ra te Ba n k in g, Co mm e rc ial la n d re ta il Ba n k in g )w ith a zeal to lea rn, a n d p ro ve n a b ility to excee d g o a ls in a h ig h -p re ssu re m a rke t c ond ition .
  • Good lead e rsh ip a n d in te rp e rson a l sk ills, c oup le d w ith a p ro ve n a b ility to m a n ag e a tea m in p ro v id in g exce lle n t c u sto m e r re la tio n a n d ac h iev in g g ro w th .
  • Ca p a b le o f c o mm un ica tin g e ff ec tive ly in spo ke n a n d w ritte n En g lish .
  • I a m a Mo tiva te d, e n e rge tic a n d g o a l f o c u se d p ro f e ssion a l w ith a c on siste n t d e sire to su ccee d .
  • S e lf -sta rte r w ith d riv e to se e ta sk s th rou g h t o c o m p le tio n a n d to m ee t d ea d lin e s.

TECHNICAL SKILLS:

RDBMS: SQL 2005, SQL 2008/2008r2, SQL 2012, SQL Server 2014. Database Administration, Enterprise Environments, Tuning with SQL Profiler, Clustering, SQL Server Integration Services.

Operating Systems: Windows NT/ 2000/2003/2008/2008 R2/2012R2

PROFESSIONAL EXPERIENCE:

Confidential

Consultant SQL Server DBA

  • Installing SQL Server with standard access privileges service account to improve security and to attain high ratings in Sox and PI audits.
  • Installed, configured SQL Server 2008R2 Clustering on Microsoft Clustering services (MSCS) for Active-Passive and Active-Active cluster Nodes.
  • Involved in Analyzing and Upgrading SQL Server 2000 servers to SQL Server 2008R2.
  • Perform SQL Server service pack and Windows Service pack upgrades.
  • Designed and implemented comprehensive Backup plan using Native SQL and BUR and EMC DDBoost
  • Resolved and tweaked memory pressures caused during production release.
  • Worked with customers on Application rollouts and server migrations.
  • Migrated legacy databases with upgrade from SQL 2005 and 2008R2 to SQL 2012 and SQL 2014 with Always-On configuration.
  • Supported Very Large databases (VLDB) and troubleshooting related problems.
  • Strong experience in mentoring team members and writing documentation.
  • Troubleshoot performance problems and fine-tuning of databases.
  • Expertise in designing databases and capacity planning.
  • Experience with rebuilding the indexes and statistics update at regular intervals for better performance.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
  • Provide 24x7 production support for SQL Server databases on standalone and Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
  • Worked extensively with Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Transferring the data (ETL) to Data warehouse with SQL Server 2005 and 2008R2 Integration Services.
  • Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.
  • Implemented and Scheduled Replication process for updating our parallel servers in autonomous sites.
  • Designed and created databases, tables, views, store procedures and triggers.
  • Handling Memory configurations for SQL Server 2012 and SQL Server 2008R2 on Windows 2008R2.
  • Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
  • Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Confidential, Atlanta, GA

SQL Server DBA

  • Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
  • Performed the migration of SQL Server 2000 to SQL Server 2005.
  • Configured the servers on 32 bit and 64 bit clustered and standalone server environments
  • Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
  • Responsible to Monitor and troubleshooting Log Shipping.
  • Implemented and maintained Database mirroring as a Disaster Recovery Solution.
  • Installed and Upgraded from SQL Server 2000 and 2005 to SQL server 2008 R2 on Various Production Servers.
  • Migrated Databases from SQL Server 2005 and SQL Server 2008 legacy application to SQL Server 2012 with deprecation of clustering and mirroring HA solutions and replace with Always On solution.
  • Worked with table partitioning (SQL Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
  • Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.
  • Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
  • Used Policy Based Administration feature (SQL Server 2008 R2 and 2012).
  • Worked With 'insert' commands to programmatically INSERT data if it does not exist or UPDATE the data if it does all in 1 set of logic (SQL Server 2008).
  • Created new database objects like Tables, Procedures, Functions, Indexes and Views using T - SQL in Development and Production environment for SQL Server 2005 and 2008 R2 and 2012
  • Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
  • Worked in Active-Active Cluster environment as a High availability solution.
  • Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
  • Extensively used TSM litespeed backups
  • Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
  • Expert in Performance Tuning of the Stored Procedures.
  • Checking Database Health by using DBCC Commands and DMVS
  • Monitored and modified Performance using execution plans and Index tuning.
  • Experience in Database security and integrity planning
  • Used log shipping for synchronization of databases.
  • Prepared Documentation for the Disaster Recovery plan
  • Designed Data Integrator jobs with Error Handling and email notifications.
  • Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
  • Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
  • Daily routine DBA tasks like handling user's permissions and space issues on Production and Test servers

Confidential, houston, tx

Business Risk Consultant

  • Populated the control matrix with control objectives, assertions and developed the risk statements
  • Reviewed non-conformity with company’s policies and procedures in relevance with industry standards and providing constructive feedback on process documentation and control assessment work
  • Evaluated documentation, and testing of Sarbanes-Oxley IT requirements for compliance
  • Identified IT control gaps, document our findings and clarify evidences with process owners.
  • Discussed findings with clients to obtain their consent.
  • Prepared draft report, re-test and double-check findings
  • Worked with process owners and other infrastructure team to identify, document and monitor remediation plans. Ensure remediation plans are in place, advice management where key controls are not adequate. Support remediation efforts to strengthen internal controls in areas of potential & identified weaknesses.
  • Recommended changes to existing business processes and procedures, manage corrective action initiatives, review test samples and results, and document status via periodic status reports.
  • Assisted in completing the Audit Plan for Internal Audit.
  • Obtained necessary background information on assigned audit areas through review of materials including, but not limited to, operating procedural manuals, policies, pertinent regulations, prior year work papers and reports, and discussions with department personnel.
  • Performed audit steps assigned with diligence; properly documented test work in accordance with department and professional standards.
  • Involved in Collecting, analyzes, interprets, and documents information to support audit results

Confidential, Houston, TX

Staff Auditor (Contractor)

  • Assisted in identifying and evaluating the organization’s risk areas and provides input to the development of the Annual Audit Plan.
  • Performed audit procedures, including identifying and defining issues, developing criteria,
  • Reviewed and analyzing evidence, and documenting client processes and procedures.
  • Conducted interviews, reviews documents, develops and administers surveys, composes summary memos, and prepares working papers.
  • Identifies, developed, and documents audit issues and recommendations using independent judgment concerning areas being reviewed.
  • Assisted in communicating the results of audit and consulting projects via written reports and oral presentations to management and the Board of Directors.
  • Participated in meeting to define scope and timing of Audit
  • Identified, documented and assisted process flow points where potential errors were likely to occur, internal controls.
  • Assisted in completing the Audit Plan for Internal Audit.
  • Tested controls to enhance operating efficiency and effectiveness
  • Reviewed audit finding and recommendation
  • Assisted is testing of controls base on Audit program and help to identify control risk
  • Prepared draft audit report for review.
  • Provided advisory services on audit, accounting and system issues as assigned
  • Obtained necessary background information on assigned audit areas through review of materials including, but not limited to, operating procedural manuals, policies.

Confidential, Houston, TX

Management Accountant

  • Developed and produce financial statement for different operational unit of the company. This includes Monthly management account, profit and loss account, and budgets cash flow reconciliation/variance analysis.
  • Assisted in budgeting and planning process for different operational units.
  • Establishes and maintain financial policies and reporting tools for the organization, basedSS on their business process.
  • Assisted in Report on company assets and liabilities including balance sheet account reconciliation.
  • Reviewed and maintained AR, AP for projects
  • Provided management reporting for decision making.
  • Project appraisals, evaluations and post implementation analysis
  • Assisted in managing capital expenditure and production of forecast.
  • Performed day to day accounting responsibilities and handle payments for service providers.
  • Reviewed working accounting practices and processes to ensure efficient and cost effective operations.

Confidential

Teller/Investment Banker

  • Assisted customers with opening, closing accounts and other branch servicing duties such as cash and vault balancing; ordering checks and other supplies; completing logs, reports, audits and control checks
  • Developed and expand customer relationships through marketing displays, call programs, and other prospecting techniques.
  • Planned personal sales and referral goals by identifying, marketing, and cross-selling banking products and services beneficial to customer needs.
  • Performed cash handling functions (deposits, withdrawals, cash advances, payments, transfers, check cashing, etc.)
  • Assisted in addressing customer questions and concerns by phone and in person; files disputes or refers to appropriate internal resources for resolution as appropriate
  • Balancing cash drawer and teller transactions
  • Assisted customer's in identifying their financial needs and offer appropriate products and services
  • Assures compliance with all Bank policies and procedures and all applicable state and federal banking laws, rules and regulations
  • Processes, solves and answers complex customer transactions, problems or inquiries
  • Ensures compliance with all applicable reporting and recordkeeping requirements
  • Identifies and mitigates potential risk issues against the Bank; interacts with Bank personnel pertaining to such issues
  • In depth knowledge of consumer and small business lending regulations

Hire Now