Description
SUMMARY: * 6+ years experienced in Data Modeling, Relational Database Architecture and Implementation, Systems Architecture and Development, Database Administration and implementation of Administration Standards. Over the years, have been involved in large number of project development, managed large number of Projects & been a DBA with large number of Database Servers. * Experienced to deliver data management vision, goals, priorities, design principles, and operating policies in support of the business goals of the organization. * Experienced in the Agile software development process including working with the business to prioritize requirements into logical and manageable groups for rapid intake into the Agile development process, based on development resource capacity. * Designed and developed enterprise-level solutions (For ERP system such as SAP, IBM AS400) for very large multidimensional databases 10 - 15 Terabytes) * Expert level of experienced to develop database solutions by designing proposed systems, defining database physical structure and functional capabilities, security, back-up, and recovery modes (compliant to Business's RPO And RTO). * Experienced in determining database structural requirements by analyzing use-cases and performance objectives, including high availability using high availability solutions like Clustering, Database Mirroring, Log Shipping, and Replication of databases for large, medium and small customers to further increase scalability and stability of business-critical systems. * Experienced in working with 24/7 production Environment with thorough understanding of Standard Operation Procedures (SOP) and Service Level Agreements (SLA). * Experienced in data center migration from existing databases to remote data centers. * Intensively experienced in monitoring/tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor. * Experienced in managing databases on multiple disks using Disk Mirroring and RAID technology. * Experienced in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks. * Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy (BCP). * Expert knowledge of Cross platform Reporting tool such as SSRS, Cognos, Tableau etc. * Designed and implemented operational automation tasks using SQL Server Job using PowerShell/T-SQL scripting. * Expert level skills in Clustering, Replication, Data Modeling (Physical and Logical), Server Mapping, Installation and Configuration, up gradation from previous versions. * Experienced in creating maintenance plans to perform index defragmentation, re-indexing and update Statistics. * Proficient in troubleshooting database issues. * Experience in Creating Roles and managing user permissions, Jobs, Alerts, SQL Mail Agent, and using performance monitor/profiler for resolving deadlocks. * Experienced in Design, Development, Testing, Implementation and production, support SDLC of Client/Server, and Web based applications. * Team player with Good communication, interpersonal and business analysis skills.