We provide IT Staff Augmentation Services!

Sr. Sql Server Database Administrator Resume

Boca Raton, FL

SUMMARY

  • Over 12 years of experience, including 8 years as SQL Server DBA\BI\Cognos Admin
  • Ensure SQL database systems operate efficiently and securely.
  • Manage internal databases, from planning and testing stages through implementation and support.
  • In - depth understanding of security and backup procedures to ensure database integrity. Background in developing backup and disaster recovery plans for database servers
  • Superior communication, presentation, analytical and problem solving skill. Work well with all levels of business.

TECHNICAL SKILLS

  • Microsoft SQL 2000/2005/2008 R2/2012 2014
  • Windows 2000/2003/NT/XP
  • Windows 95/98
  • Windows 2000/2003 server
  • Red Gate SQL Bundle (SQL Compare
  • SQL Data Compare)
  • Microsoft Visual Studio.NET
  • SourceSafe
  • Lotus Notes
  • Microsoft Outlook
  • Microsoft Office
  • Word
  • Excel
  • PowerPoint
  • Access
  • Project
  • Visio
  • Internet Explorer
  • Mozilla Firefox
  • LiteSpeed
  • Cognos BI 10.2
  • Cognos Planning 10.1.1

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL Server Database Administrator

Responsibilities:

  • Maintains the day-to-day operation of the company’s database systems (interact with development teams)
  • Ability to write t-sql, debug and tune procedures, functions and ETL packages
  • Monitor application related SQL Server jobs and transactional replication activities (failures)
  • Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
  • Troubleshoot outages as they occur, including after-hours, weekends and holidays
  • Perform development and maintenance assignments as needed.

Confidential

Sr. SQL Server Database Administrator\ SQL BI Admin

Responsibilities:

  • Maintains the day-to-day operation of the company’s database systems (interact with development teams)
  • Modify stored procedures, created t-sql queries to automate tasks and building of ETL packages
  • Discover, analyze and resolve problems related to all database applications and also resolve reporting issues
  • Implementing new releases; completing maintenance requirements; evaluating operating systems and hardware products (change control)
  • Monitor application related SQL Server jobs and transactional replication activities (failures)
  • Work with developers to manage the design, release, and maintenance of all in house database projects
  • When performance issues arise, determine the most effective way to resolve performance including hardware purchases, server configuration changes, or index/query changes…query tuning using execution plans
  • Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
  • Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
  • Troubleshoot outages as they occur, including after-hours, weekends and holidays
  • Perform other assignments, as needed.
  • Acts as the change control manager, implementing approved changes.
  • Contribute to the overall Continuous Improvement Process within the organization
  • Administering, maintaining, developing, and implementing policies and procedures for ensuring security, integrity, and quality of the company’s databases
  • Adhere to a Service Level Agreement for all database Systems and Ensuring compliance with database vendor license agreement
  • Execute production data updates/fixes, as needed
  • Installing and upgrading the database server and application tools
  • Allocating system storage and planning future storage requirements for the database system
  • Modifying the database structure, as necessary, from information given by application developers
  • Enrolling users and maintaining system security
  • Controlling and monitoring user access to the database
  • Contacting application vendors for technical support
  • Generating various adhoc reports by querying from databases as needed
  • Manage and sync test, dev and production databases
  • Identify database requirements by analyzing department applications, programming, and operations; evaluating existing systems and designing proposed systems.
  • Responsible for data transformation process that feeds the data warehouse on a regular basis
  • Currently On-Call 24hr production support

Confidential

Business Application Support

Responsibilities:

  • Implement approved changes via change control
  • Modifying the database structure, as necessary, from information given by application developers verbally
  • Write, execute, review, and optimize SQL scripts as needed implement scripts and interact routinely with development team
  • Generating various reports by querying from database as per need

Confidential

Cognos Administrator\Cognos DBA

Responsibilities:

  • Provide support for Cognos BI and Planning environment (Virtual & Physical)
  • Production support, performance tuning in multi-server environment
  • Made sure data and procedures compliant with all industry best compliances such as Sarbanes-Oxley Act and Hippa requirements
  • Modifying existing Framework Models, packages and cubes
  • Maintain security within Cognos environment
  • Upgraded from BI version 10.1 to 10.2 and Planning 10.1 to 10.1.1
  • Maintain cube refresh schedules along with reports schedules and provide support for performance issues
  • Responsible for all Cognos backend SQL server changes admin tasks
  • Create and modify stored procedures, view and other t-sql tasks in order to better support reporting environment
  • SSIS data conversions (migrating data from new acquired practices using SSIS), SSRS configuration and building of scheduled ETL processes.
  • Backup processes, replication. Installing and upgrading of MS SQL

Confidential

Senior SQL Server Database Administrator

Responsibilities:

  • Manage 100+ database servers with 1,200 databases in a fully redundant, high capacity, multi-location, high volume transactional environment
  • Delegating and distributing daily individual and team database tasks
  • Set up transactional replication, monitor and resolve all conflict resolution errors
  • Install, configure and fine tune all new Microsoft SQL 2005/2008/2012 database instances. Install service packs and hotfixes
  • Perform database space management on all database servers; database file allocation management
  • Work with developers to design and develop schema to maximize performance, ensure data integrity and proper database design
  • Use SQL Compare to compare schema and data between databases and perform synchronization
  • Script, implement and support production schema and code migrations to ensure the integrity and availability of databases
  • Lead for disaster recovery plan - executed plan, implementation and successful test for yearly Disaster Recovery exercise
  • Business Continuity Coordinator - created and maintained documentation for the DBA team
  • Migrate SQL agent jobs, users and groups along with permissions; set up log shipping
  • Use SQL LiteSpeed to backup and restore databases using high compression
  • Completed a synchronization project involving the migration of over 200 stored procedures and hundreds of schema modifications performed with minimal impact
  • Upgraded environment from SQL 2005/2008 to SQL 2012
  • Upgraded environment from SQL 2000 to SQL 2005 along with upgrading from 2005 32bit to 2005 64bit
  • Support day to day DBA related production issues
  • Purged large amount of client data from production databases
  • Manage user logins and permissions on all database servers

Confidential

SQL Server Database Administrator

Responsibilities:

  • Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000, 2005 and 2008
  • Developing and monitoring SSIS and DTS packages along with migrating from SQL 2000 to 2005
  • Hands on and solid experience and outstanding knowledge of high availability SQL Server solutions
  • Monitor, tuning and analyzing db performance and allocating server resources to achieve optimum db performance.
  • Working Experience in designing, implementing, maintaining, and documenting complex database applications
  • Experience with installation and configuring of Microsoft Reporting Services
  • Excellent communication, presentation and interpersonal skills
  • Strong troubleshooting and organizational skill

Confidential, Boca Raton, FL

Database Implementation Site Manager

Responsibilities:

  • Define and configure interfaces to real estate (MLS) data sources
  • Create and update SQL server databases
  • Data Transformation Services and data conversions
  • Database tuning
  • Perform regular analysis and integrity checks on data to ensure completion and accuracy.
  • Responsible for configuration, implementation and deployment of Confidential software.
  • Build and manage custom parallel databases that mimic RETS

Confidential, Plantation, FL

Contract SQL Server Database Administrator

Responsibilities:

  • Discover and resolve new database compatibility problems resulting from company wide platform conversions
  • Identify and document issues for the American Operations Corporate Accounting, Finance and Tax departments
  • Conduct meetings with VPs and Senior department Directors to define issues and recommend solutions
  • Collaborate with department directors and managers to facilitate consolidation of multiple merged companies with various home grown Access databases
  • Database functions include analyzing of legacy Access databases for migration to SQL Server
  • Support for all non corporate DHL employees using MS Access via remote connections

Confidential, Ft. Lauderdale, FL

SQL Database Administrator

Responsibilities:

  • Data Transformation Services (DTS) and data conversions of business requirements to system functionality
  • Monitored and repaired all transaction replication issues
  • Installed MS SQL, configured, applied service packs, testing and development on WinNT platforms
  • Monitored and tuned SQL Server databases
  • Provide support for call center database
  • Involved with disaster recovery planning
  • Maintained and supported multiple SQL servers in production and test environments
  • Automated various day to day procedures such as database synching, moving and restoring databases, dropping and recreating logins and users in order to experience less down time
  • Automated methods of copying database backups from field offices to corporate offices for archiving using compression cabarc and NetIQ as tools
  • 24 hour on call support for database related issues

Confidential, New York, NY

Senior Systems Analyst

Responsibilities:

  • Installed, customized and supported software for clients on and offsite
  • Created customized FoxPro validation programs for clients by request
  • Serviced clients in multi-locations by using remote control applications or conducting on site visits
  • Trained new employees and clients on in house applications as well as business rules
  • Provide support for customers utilizing Client Server base applications (ASP, GUI and FoxPro)
  • Created import and export programs written in FoxPro for customer data conversions
  • Performed high volume of client database conversions (from client data to FoxPro to SQL 6.5 and 7.0)
  • Responsible for database backups and recoveries
  • Supported end users with software, hardware and basic server administration issues
  • Create custom reports linking to various databases using Crystal Reports, and R&R Report Writer
  • Managed MSDN library and TECH NET software subscriptions from Microsoft

Hire Now