SQL DBA/Developer/Tester Resume Rockville, MD - Hire IT People

SUMMARY

Over 3 years of experience and exposure in Database Administration, Design/Development and Support of MS SQL Server 2008, 2008R2 and 2012 in production, test and development environments.
Extensive knowledge of Relational Database Management Systems.
Experienced in MS SQL Server Installation, Configuration, Security Implementation, Back - Up/Restore/Disaster Recovery, Performance Tuning/Troubleshooting, High Availability and Database Maintenance.
Experienced in working with T-SQL to write queries.
Experience in creating/working with Stored Procedures, Indexes, Views, and Triggers.
Experienced in creating SSIS packages in SQL Server to transfer data
Experience in Data Modeling and Development.
Good knowledge of Software Development Life Cycle (SDLC).
Experienced with Windows Server 2003/2008 Enterprise Editions, and Windows XP.
Experienced in Quality Analysis Testing and Business Requirements gathering in Agile environment.
Excellent interpersonal, analytical and communication skills with extensive experience in report writing, verbal communication, correspondence and documentation.

PROFESSIONAL EXPERIENCE

Confidential, Rockville, MD

SQL DBA/Developer/Tester

Responsibilities:

Install and Configure SQL Server in both clustered and standalone servers.
Involve in data modelling and database designs.
Write queries, stored procedures, views, triggers using T-SQL and translate business requests and requirements in to T-SQL programming solutions.
Streamline the server/database level security by creating the Windows and SQL logins with the appropriate server/db roles and object level permissions.
Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO).
Test backups to ensure the business’ Recovery Time Objectives (RTO) are met.
Use DBCC and create maintenance plans including Rebuilding/Reorganizing indexes.
Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery, performance monitoring and database maintenance.
Use free tools like sp Blitz™ to diagnose server reliability and performance issues.
Configure Database Mirroring, Log Shipping and Replications.
Export & Import data to/from SQL Server Database using Bulk Insert, SSIS, and BCP.
Perform installation of SQL Server Service Packs (SPs), Cumulative Updates/hotfixes.
Test New Software, new websites, databases for updating purposes and report on platforms like JIRA, Sharepoint.
Involve in capacity planning, database updates and growth projections as part of development team.
Document the company’s database environment with emphasis on detail.
Participate in technology seminars for skills update and enrichment.

Confidential

Jr. SQL Developer/DBA

Responsibilities:

Actively use both written and verbal communications to correspond, document and cooperate with work units, project leaders and administrators.
Create Entity Relationship (ER) Diagrams to the proposed database
Identify columns for Primary Keys in all the tables at the design time and create them
Create/Develop/Modify/Alter database objects such as schemas, tables, views, stored procedures, triggers using T-SQL.
Perform testing on system stored procedures, dynamic management views and functions.
Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints.
Implement security by creating customized logins/users, minimizing the number of sysadmins and implementing robust password policy.
Take backups of database in line with Recovery Point Objectives (RPO) and test them if they meet Recovery Time Objectives (RTO).
Monitor jobs to make sure all scheduled jobs run successfully every night.
Design, Develop and Deploy SSIS Packages.
Apply Service Packs (SPs), Cumulative Updates/hotfixes and patches on both SQL and windows servers.

We provide IT Staff Augmentation Services!

Sql Dba/developer/tester Resume

Rockville, MD

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship