Sql Dba/developer/tester Resume
0/5 (Submit Your Rating)
Rockville, MD
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.