•MBA in Marketing and Information technology Management and having approx. 8.2 years working experience as a Database Architect and infrastructure solution design with different clients.•Expertise in database migration ,production database support ,T-SQL development ,SQL profiler,SQL Server Migration Plan, solution Design for new infrastructure design for application upgrade and activity end-to-end support with Exposure towards public Azure cloud. As a Database Architect:-8.2… Show more •MBA in Marketing and Information technology Management and having approx. 8.2 years working experience as a Database Architect and infrastructure solution design with different clients.•Expertise in database migration ,production database support ,T-SQL development ,SQL profiler,SQL Server Migration Plan, solution Design for new infrastructure design for application upgrade and activity end-to-end support with Exposure towards public Azure cloud. As a Database Architect:-8.2 years of Experience in Troubleshooting SQL Server production issues, Planning Database Backup and Restore/Recovery Strategies, Creating and Monitoring SQL Server Jobs, rebuilding indexes.•Supports Multiple Projects with multiple clients’ Solution, building, migrating and support them as a SQL Database Server Infrastructure SME.•Experience in query optimization & performance tuning. •Experience in infrastructure solution design for new project upgrade on prem and consolidation of infrastructure for multiple application including costing and budget planning.•Experience in working with agile model .Well aware with the agile methodology.•Migration experience from MS SQL Server 2005 to MS SQL Server 2008, MS SQL Server 2008/2008R2 to MS SQL Server 2012/2014/2016/2017/2019.•Experience to Migration and maintenance in-premises Database to Azure.•Experience managing the security Auditing and compliance management as per infra and organization Standard.As Infrastructure solution designer:-•Designing the architecture Solution for new build Application and present it to client.•Have a good Exposer in cloud migration and creation plan for it. •Build Application, web, database server as per the need of application team though terraform, chef and Inspec.•Designing and providing the solution for small projects to provide the best solution according to the business need.•Building and designing physical and database server according to the client need. Show less

MSSQL database administrator

 3.5 years of Experience in Troubleshooting SQL Server production issues, Planning Database Backup and Restore/Recovery Strategies, Creating and Monitoring SQL Server Jobs, Building / rebuilding indexes. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, DBCC Commands. Quick learner and result- oriented individual with strong analytical aptitude and effective interpersonal and communication skills. Experience in using SQL Server Tools like… Show more  3.5 years of Experience in Troubleshooting SQL Server production issues, Planning Database Backup and Restore/Recovery Strategies, Creating and Monitoring SQL Server Jobs, Building / rebuilding indexes. Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, DBCC Commands. Quick learner and result- oriented individual with strong analytical aptitude and effective interpersonal and communication skills. Experience in using SQL Server Tools like Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer Migration experience from MS SQL Server 2005 to MS SQL Server 2008, MS SQL Server 2008 to MS SQL Server 2012 Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them). Experience in Database backup and disaster recovery process. Performed Log Shipping and implemented Replication as High Availability techniques. Experience in Database Mirroring as Disaster Recovery Solution. Experience in Creating Tables, Views, Triggers, Cursors, Dynamic Stored Procedures, User Defined Functions and other Transact-SQL (DDL, DML) statements for various applications. Tracked Server Activity, Query Performance and Disk usage activity statistics via Performance Data Collection. Experience in optimizing the query by creating various clustered, non-clustered indexes and indexed views. Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling them. Basic understanding of Relational Database Management Systems. Has the ability to work in a fast paced environment, Good team player and can work independently. Helped the database developers on technical issues. Comfortable with all the shifts and can provide 247 support when required. Experience in Disaster Recovery planning and implementation. Experience in application support related to SQL Server and other application. Show less