SQL Server Admin & Developer Resume

SUMMARY:

Quick learner, self - motivated and results-oriented Professional with exposure to the four fundamental actions of data analysis: collection, transformation, analysis and presentation.
Experience developing, maintaining and analyzing SQL database environment.
Ability to be analytical, creative and innovative; building and maintaining databases and reporting systems.
Self-starter who performs well individually or as part of a team.
Furthermore, who carries a strong desire for constant grow of knowledge and learning. Looking for a career opportunity that will continue my growth in the Information Management
Microsoft SQL Server Windows Server Internet Information Server
SQL Reporting Services Virtualization Environment Microsoft Active Directory
SQL Analysis Services Remote Management TCP/IP/DNS/WINS
SQL Integration Services Microsoft C# HTML, ASP.NET, Javascript

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server Admin & Developer

Responsibilities:

Designing and implementing relational database model as per business needs.
Configured Replication and Database mirroring.
Installed & Maintained Microsoft SQL Servers 2014, creating and managing users & permissions, designing relational Databases
Supported clustered (Active-Passive) and non-clustered environments.
Involved in trouble shooting and fine-tuning of databases for its performance
Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support
Analyze long running slow queries and tune the same to optimize application and system performance
Support & Developing .NET Applications, Install & Configure IIS, SSRS, Networking Troubleshooting, Active Directory, HyperV, VMWare

Confidential

SQL Database Developer

Responsibilities:

Designing and implementing relational database model as per business needs.
Installed & Maintained Microsoft SQL Servers 2012, creating and managing users & permissions
Working with Failover Clustered environments and implementing replication database servers ( Merge )
Creating indexes, Views, Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support
Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement

Confidential

SQL Database Developer

Responsibilities:

Designing and implementing relational database model as per business needs.
Analyzed SQL server environment for quality checks.
Conducted data migrations from third party databases to create consolidated database system
Creating indexes, Views, Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
Coordinated with the management to discuss business needs and designed database solutions accordingly

Confidential

SQL Server Admin & Developer

Responsibilities:

Installing and managed reports using SQL Server Reporting Services
Rebuilding/Monitoring the indexes at regular intervals for better performance
Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions
Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
Identifying solutions and improving SQL Server queries to the optimal state for fast access and data retrieval
Coordinated changes to computer databases. Reviewed new programs or modifying existing programs.
Adding users and rolls behind different level of access
Installed and maintained FTP, IIS, and mail servers