Sql Dba Resume
3.00/5 (Submit Your Rating)
SUMMARY
- SQL Server DBA with experience in project management, people management, solution development, system integration roles in a career spanning 15 years, giving a well - rounded experience on various customer scenarios.
- Experience in SQL database administration on production, staging & development servers with server configuration, performance tuning, and maintenance with excellent troubleshooting capabilities.
- Experience in Disaster Recovery Planning, SQL Server Replication, Backup/Recovery and Security Management operations.Having hands on experience in DR processes including Log Shipping and Database Mirroring.
- Experience in data transformation services like SSIS, DTS, BCP and Bulk Insert.
- Experience in performing integrity checks. Methods include configuring the database maintenance plan wizard and DBCC utilities.
- SQL Server Setup, Installation & Version Upgrade.
- Plan, Design and Scheduled Database Maintenance & Administrative Tasks.
- Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
- Create, manage SQL Server AZURE Databases. Setting up SQL Azure Firewall. Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio (SSMS) for Developers.
- Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
- A multidimensional profile with Six Sigma Green Belt, capable and experienced in handling Database Administration, project, people and solutions management.
TECHNICAL SKILLS
- Storage
- ISS
- ERP
- Web Dev
- ERWIN
- MS Project, MS Office
- Client server, web-based
- Dot Net, ASP, XML
- PeopleSoft
- Windows
- SQL Server
- Oracle
PROFESSIONAL EXPERIENCE
Confidential
SQL DBA
Responsibilities:
- Migrating database to RDS instance.
- Setting up Connection Strings and connecting to SQL Server RDS instances from locally Installed SQL Server Management Studio (SSMS) for Developers.
- Querying servers for getting details of users/logins.
- Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
- Performed Production support and on Call duties.
Confidential
SQL DBA
Responsibilities:
- Configure trace to identify users/logins accessing orphan/unmapped servers.
- Responsible for all SQL Server General Administration and Performance.
- Setup backup and restoration jobs for development and QA environments.
- Performed installation of SQL Server & Service Packs.
- Suggested Disk Capacity, Processors and Memory based on the Capacity planning.
Confidential
SQL DBA
Responsibilities:
- Ensure all the SQL SERVER features worked as expected after consolidation or fail over.
- Help the developers & testers understand & debug issues related to SQL Server.
- Security and architectural planning issues met as well as testing and training.
- Failover cluster testing and resolution on HP servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
- Performed installation of SQL Server &Service Packs.
- Instrumental in transition & steady state of various responsibilities.
- Used DBCC checks to ensure the physical consistency of the database and objects post failover & consolidation.
- Providing support to the Application developers on the application databases.
- Performed Production support and on Call duties.
Confidential
SQL DBA
Responsibilities:
- Responsible for General Database Administration and Performance.
- Upgrading PRISM database to SQL 2008.
- Rebuilding / Monitoring the indexes at regular intervals for better performance.
- Implementing point in time recovery solution.
- Monitoring of database size and disk space in Production, Staging & Development environments.
- Performed installation of SQL Server & Service Packs.
- Setup backup and restoration jobs for development and QA environments.
- Used DBCC checks to ensure the physical consistency of the database and objects post failover & consolidation.