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