Profile Summary

• Microsoft Technology Certified, SQL developer experienced in development and maintenance of Database systems as well as Business Intelligence utilizing SSIS, SSRS, SSAS, Configuration, Performance Tuning, Administration, Backup/recovery, Maintenance, Security and Data Schema Modeling
• High Availability and design, T - SQL SQL - developing stored procedures, functions, triggers, scripts - custom code, Dimensional / Logical / Physical schemas, integration, DB provisioning, management, and data integrity in high traffic / high business critical data centric applications availability environments
• OLTP / OLAP, Data warehouse / DSS Database development /design
• Significant experience in developing enterprise Software Development Life Cycle methodology SDLC, operational assessment analysis, Object Oriented OO DB development, documenting and technical writing. Balance of technical and business analytical skills.
• Hands-on experience in enterprise Application, RDBMS development, translating business requirements into functional and development requirements

Technical Summary

• RDBMS Database Development: Microsoft SQL Server R 2000, Microsoft Access, MySQL, PostgreSQL, Sybase Operating System and storage platform: WinTel Microsoft Windows Server, Linux RedHat, CentOS, Ubuntu, Veritas SQL Server Software: Microsoft Visual Studio, Microsoft MS SQL Server Management Studio, SQL Profiler, Query Analyzer, SQL Configuration Manager, SQLCMD, OSQL, ISQL, Management Data Warehouse MDW, Microsoft Dynamic GP, MS SharePoint, Quest Software: Quest Foglight, SpotLight, SQL LiteSpeed, ERwin, Embarcadero ER/Studio XE Data Architect, Enterprise Architect, TOAD, RedGate Tools, Software: SQL Developer, AppWorx / UC4, Cron, SQLdump, SQL Import, SQLExport, XML tools, VMware, Eclipse, JRE, PowerDesigner, Cygwin, Putty, Rapid SQL, Citrix, MS Project, MS Visio, NAS, SAN, Github, xCase Web server: IIS, Apache Tomcat, AWS Software Configuration Management SCM and lifecycle management solution: System Center Configuration Manager, JIRA, Serena Dimensions, SVN, CVN, Git, GitHub, Team Foundation Server TFS ETL framework and reporting solution: SSIS, SSRS, SSAS, BIDS, BIDT, Cognos Network: TCP/IP, SFTP, FTP, SSH, VPN, NIS, NFS, HTTP s, DHCP, Telnet, SAN, NAS FTPS, FTP, PGP encryption, Cloud / Distributed computing Hardware/Storage: SAN, RAID
• ETL framework and reporting solution: Integration Services SSIS, Analysis Services SSAS, Reporting Services SSRS, Business Objects BODI, BODS, Crystal Reports
• Programming Languages and Framework: Transact-SQL T-SQL, C, SQL, SQL ANSI-92, 99, 2003, Wintel, Shell Scripting, XML, UML, PowerShell, SaS
• Operating System and storage platform: WinTel Microsoft Windows Server, Linux RedHat, CentOS, Ubuntu
• SQL Server Software: Microsoft Visual Studio, Microsoft MS SQL Server Management Studio, SQL Profiler, Query Analyzer, Service Broker, SQL Configuration Manager, Performance Monitor PerfMon, SQLCMD, OSQL, ISQL, Management Data Warehouse MDW, Microsoft Dynamic GP, MS SharePoint, Quest Software: Quest Foglight, SpotLight, SQL LiteSpeed, ERwin, Embarcadero ER/Studio XE Data Architect, Enterprise Architect, TOAD, RedGate Tools
• Software: SQL Developer, AppWorx / UC4, Cron, SQLdump, SQL Import, SQLExport, XML tools, VMware, PowerDesigner, Cygwin, Putty, Rapid SQL, Citrix, MS Project, MS Visio, DB Artisan, xCase
• Web server: IIS, Apache Tomcat, AWS
• Software Configuration Management SCM and lifecycle management solution: System Center Configuration Manager, JIRA, SVN, CVN, Git, GitHub, Team Foundation Server TFS
• Network: TCP/IP, SFTP, FTP, SSH, VPN, NIS, NFS, HTTP s, DHCP, Telnet, SAN, NAS FTPS, FTP, PGP encryption, Cloud / Distributed computing
• SDLC Experience
• SDLC Agile and Scrum Project development:
• Program Management Methodology, Project Management Life Cycle PMLC, Software Development Life Cycle SDLC methodology, Change Requests, Change Management procedures. Project ownership
• Operational analysis and technical assistance, creating Use Cases UML diagrams, workflows, Design Flows etc
• Translating enterprise business processes BMP requirements in to software development logic, developing UML schemas / Class diagrams
• Performing complex custom data analysis across database environment infrastructure, diagnosing and solve interfacing and compatibility issues
• Developing Functional and technical test cases to support QA and UAT testing
• Application data schemas platform design, development and support for high-availability / multi-node replication, clustering on Windows based database platforms MS Clustering, MS Replication

Work Experience

Confidential

• Database design and development - MS SQL Server instances 2012, 2008 R2, 2008, 2005, 2000
• Custom code development, configuration and deployment - SSIS, DTS BI systems, troubleshooting ETL database performance problems.
• Developing ad-hoc and custom reports for business analysis using Crystal Reports, SSRS, SSAS etc
• Developing SSIS code, Batch custom code, shell scripting, Wintel C, PowerShell, Perl etc
• Developing custom code interfaces between MS SQL Server and Sybase, Oracle, MySQL, Netezza, Vertica, Informix, DB2, Teradata - data migrations, extractions and interface mappings between multiple databases Service oriented code creation using XML data exchange
• Creating custom code T-SQL DDL, DML Databases, Stored Procedures, User Defined Functions UDF, Triggers, Tables, Views, indexed Views, Custom Jobs, DTS, XML, XSLT, XQuery, shell programming code development etc
• Creating DB Backup T-SQL jobs - FULL, Differential and Transaction Log
• Creating scheduled DB Jobs for database maintenance Indexes integrity / fragmentation, rebuild and statistics
• Creating SQL Server CDC Change Data Capture data auditing solution
• Creating shell / batch / PowerShell programs to move backup and data flat files onto backup FS servers
• SQL Server / Windows Server system resources - Performance Monitoring and Performance tuning SQL Profiler, Performance Monitor PerfMon . Performance analysis using DMV Dynamic Management Views / functions
• MS SQL Server data migration different releases from 2008 R2 to 2012, from R2, from etc
• Data / Code Migration MySQL, Oracle databases to SQL Server 2008 R2 and 2012
• Security patching applying rollout of SP Service Pack
• Installing and configuration of Virtualization environment on VMware platform / DB Instances
• Creating DR - Disaster Recovery system design and solution implementation. Recovery of transactional data, and DB recovery automation
• Responsible for RDBMS Data design, utilizing data schema industry tools - developing data architecture schemas.
• Developing SSAS Cubes / Logical / Physical / Dimensional Data Models - Star schemas, SnowFlake schemas, Object Oriented OO schemas - Using normal forms Normalization, De-normalization development technique's
• Application systems performance problems analysis, diagnoses and optimum performance resolution, system stability and scalability - employing preventive measures to maintain high applications availability, performance monitoring, identifying root cause and resolving database performance bottlenecks, T-SQL tuning / tracing
• SSMS T-SQL query execution plan - showplan xml, Indexing, Data and OS level optimization
• Developed solution for complex joins, creating dynamic T-SQL code / scripts to support system analysis, and troubleshooting SQL queries performance issues
• Performing data access analysis design, creating archive/recovery design and rollout implementation
• Developing new data migration strategies, data archive recovery, and implementation of DB / Data platforms
• Archive Job Execution and monitor data archives files processes
• Responsible for supporting integrity, availability of database systems for high traffic business critical network of web application.
• Developing custom applied statistics and analytics algorithms / automated process to ensure data integrity and identify potential data errors. Developing service-oriented architecture - SOA DB programming and scripting
• On-call shift 24 x 7 production environment, support database recovery, schema changes and DB upgrades
• Developing technical strategy of all Database OLTP, Data Warehouse OLAP initiatives for the business clients
• Data conversion from any data source to database Transact-SQL custom code development configuration and implementation
• Developing Data Sharding and Data Partitioning scale-out solution / processes
• Database programming - Data conversion from multiple data feeds to multiple sources
• Monitoring performance, collecting, analyzing trends - developing data tuning methodologies. Database optimum performance tuning, optimizations, indexing solution, partitioning / clustering
• Creating scripts / programs using new industry standard techniques for Database environment maintenance, Data dictionary, Tablespace / Disk management
• Identifying and capturing metadata, data lineage and identifying authoritative data sources to support logistics information exchanges and system modernization activities
• Developing DWH data warehousing blueprints, evaluating hardware and software platforms, and integration systems API
• OLTP / OLAP / DWH DSS best practice database design, configuration and optimization
• MS SQL Server DB administration SQL Servers configuration and management
• Research on emerging technologies / trends, and applying appropriate solution knowledge to DB platform. Technical knowledge transfer and cross-teams training