We provide IT Staff Augmentation Services!

Sql Dba/developer/tester Resume

0/5 (Submit Your Rating)

Rockville, MD


  • 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.


Confidential, Rockville, MD

SQL DBA/Developer/Tester


  • 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.


Jr. SQL Developer/DBA


  • 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'd love your feedback!