Description
Summary: * Over 3+ years of IT experience as SQL Server DBA/Developer ( 2014, 2012, 2008/R2, 2005 ) in Production, Development and Staging, Data Warehouse Environments (OLTP and OLAP) * Maintained databases with sizes ranging from Large to Very Large Databases (terabytes). * Solid experience in database design and creation of schemas, writing stored procedures, functions, triggers, DDL and DML SQL queries. * Experience in Extraction, Transformation and Loading of data from heterogeneous sources like Oracle 10g/11g, Flat files, XML, CSV files and Microsoft SQL Server. * Strong knowledge with development in Agile methodology and Multi-tier applications. * Setting up and monitored Disaster recovery environments like Database mirroring with in the primary Data center servers and Log Shipping between primary and secondary Data center servers including Mirroring conjunction with Log Shipping. * Knowledge on programming languages like C and C+ * Managed Security like windows and SQL Logins, Roles, permissions for various users. * Experience with SQL 2012 ALWAYS ON and Data Migration from MS SQL server 2000 to 2005, 2005 to 2008, and 2008 to 2012. * Excellent Experience in Managing Security through Logins, Users, Permissions, Certificates, Credentials, Encryption Schemes per Company's Security Policies. * Created Database Snapshots on Mirror databases for generating the reports for business crew members and worked with linked servers. * Created Database maintenance plans for compressed full DB backup and transaction log backup, Check Database Integrity, Index maintenance and update statistics. * Trouble-shooted Application and Backup jobs failed issues and SQL cluster installation and cluster resources failed issues. * Configured, monitored Transactional Replication for different clients for reporting purpose. * Configured tempDB w.r.t to the no of processors and resolved Application connectivity issues like connection timeouts, connection pooling and Blocking, Dead lock issues. * Hands-on experience with SSIS (SQL server Integrated Services), SSRS (SQL server Reporting Services). * Experience in migration from Oracle to SQL Server using SQL Server Migration Assistant. * Involved in migration of DTS Packages (2000) to SSIS and troubleshoot migration issues. * Prioritized open requests and responded to the customer with an estimated completion date. Implemented security policies as they relate to the Oracle databases. * Experience in resolving on-going maintenance issues and bug fixes monitoring Informatica sessions as well as performance tuning of mappings and sessions. * Experience in server virtualization using VMware & Hyper-V. * Good knowledge of System Development Life Cycle (SDLC). * Experience in creating and managing Reporting services using SSRS and Tableau. * Experience in BI Development and Deployment of DTS, SSIS packages from MS-Access, Excel, Oracle, and Teradata. * Good knowledge in using DMVs and DMFs to finding and solving Performance Issue, Data modeling concepts. * Experience in Query Optimization, Database Consistency Checks using DBCC Utilities, and Linked Servers and also analyzing the execution plan and index management for better Query Optimization SQL Server DBA - Pureminds IT Services ltd. Atlanta GA. [Jan 2017- May 2017]
Accomplishments
Highlights:
Keywords
