Sql Server Testing

SUNDUS RASOOL

*** ***** ** **. *******, WA *****.

Phone: 425-***-****. Email: ************@****.***

OBJECTIVE:

To work in progressive organization where I can apply my knowledge and technical skills of Microsoft SQL

Server Database Administration and Testing while becoming a valued member of the team.

EXPERIENCE:

Database Administrator II Realty In Motion (Bellevue, WA) June 2013 -- Sep 2013

• Plan and coordinate data migrations between SQL Server 2005 and SQL Server 2008R2 systems.

• Respond to and resolve database access and performance issues.

• Monitor, optimize and allocate physical data storage for database systems.

• Perform database transaction and security audits.

• Utilize SQL profiler for query performance tuning and error tracing.

• Maintained the Database Consistency with DBCC at regular intervals.

• Setup Backup plans to recover up to the point-of failure to meet the business requirements.

• Responsible for monitoring and making recommendations for performance improvement by Index

creation, Index reorganize, file group modifications and adding scheduled jobs to tune Indexes.

• Administering the SQL Server by Creating User Logins with appropriate roles, dropping the logins,

monitoring the user accounts, creation of groups, granting the privileges to users and groups. Handled

orphan users while moving databases.

EXPERIENCE:

Database Administrator Conceivian Inc. (Seattle, WA) January 2009 – June 2012

• Install and Configure SQL 2005/2008 on Windows 2003/2008 environments.

• Involved in upgrading SQL Server 2000 to SQL Server 2005.

• Verify SQL scripts in code repository meet SQL formatting standard that would allow user to parse SQL

with auto-documentation tool while maintaining readability.

• Experience in Database design, writing SQL Triggers / Views / Store Procedures / Cursors for project and

utilize Data Import / Export BCP Utility for transferring data.

• Setup SQL jobs and batch jobs for backups and other scheduled tasks.

• Worked on Replication (Snapshot, Transactional) to setup larger number of subscribers.

• Configured and monitored Log shipping/Mirroring for Disaster Recovery Environment and trouble

shooting of errors

• Establish appropriate end-user database access control levels and Handle the tasks of developing security

measures to protect database security.

• Work with application development staff to develop database architectures, coding standards, and quality

assurance policies and procedures.

• Develop, implement, and maintain change control and testing processes for modifications to databases.

• Create, or support creation of, required reports in response to business user needs.

• Monitor database system details within the database, including stored procedures and execution time, and

implement efficiency improvements.

• Solid experience and troubleshooting skills with Windows 2003 and Windows 2008 Operating Systems.

• Installed and configured 2-node Active/Passive Clustering in SQL Server 2005 and 4-node Active/Active

clustering in SQL 2008R2.

• Monitoring database status including CPU, memory, I/O, space, and dead lock using SQL server Utilities.

• Use SCOM/ ProactiveNet for error alerting and trending and database capacity planning.

• Provided 24 X 7 on-call production supports.

Data Analyst 1 InCampus.com (Mankato, MN) August 2007 – August

2008

• Experience in Manual & Automated Database Testing code functionality.

• Skilled in Analysis, Design and Developing test cases for SQL objects verification and testing.

• Responsible for testing database program application and developing data models.

• Experience in Execution of Test Cases and Preparation of Test Data.

• Experience in Defect management and Bug Reporting using Quality Center, JIRA and RAID.

• Perform manual testing using Informatica (black-box), ensuring that content and structure of all testing

documents/artifacts is documented and maintained.

• Perform ad-hoc and Regression testing of system components.

• Experience in all types of Test Documentation: Test Scenarios, Test Cases etc.

• Possess good Knowledge of Software Testing Levels, SDLC, Bug Life Cycle, Testing Life Cycle and

database testing procedures

Travel Agent Asia Travel & Tourism (Abu Dhabi, UAE) June 2003 – Dec 2003

I am International Air Transport Association (IATA) certified. I was responsible for booking new

reservation and making changes to existing reservation for online and walk-in customers and ensuring

that the customers are contacted when schedule changes or cancellations occurs.

TOOLS AND TECHINICAL SKILLS:

Database Skills:

Database Migration SQL Profiler Tracing User security settings DBCC operations

Techniques

Data Protection SQL Performance Data Interface & Load Testing / ETL

Manager (DPM) Tuning Migration Testing

Test Strategies & Acceptance Testing Issue Identification & Test Plans, Cases &

Coverage Documentation Processes

Bug Tracking Logging & Reporting Data Import/Export SAN technologies

Job management Profiler Index configuration Backups

Identify blocking T-SQL for Setting object Troubleshooting

problems maintenance tasks permissions performance issues

Tools Experience:

SQL Server Management Studio, SCOM, SCSM, SCVMM, APM, Proactive Net, Quality Center, JIRA, RAID,

MS Excel, Word, PowerPoint, Outlook

EDUCATION AND CERTIFICATIONS:

Cascadia Community College (Bothell, WA) March, 2012

Advanced Database Administration Certification

Punjab College of Commerce (Lahore, Pakistan) June, 2007

Associate's Degree in Commerce

Sensum Computer College (Faisalabad, Pakistan) June, 2005

Certificate of Information Technology

ACTIVITIES AND VOLUNTEER WORK:

• Worked as Event coordinator at “Al Thuriah For Exhibition”

• Member of Water brook at Country Village community board.

Contact this candidate