VenkataRamaRao Surapaneni
Principal, Enterprise Data Architect at Avalara
VenkataRamaRao Surapaneni
Principal, Enterprise Data Architect at Avalara
Bothell, Washington
Overview
Work Experience
Principal, Enterprise Data Architect
2020 - Current
• Led the technical design, development, and execution of the company's next-gen data strategy (Project Polaris), aiding in an efficient data-driven decision-making process. • Explored emerging technologies, resulting in ML and Gen-AI use cases supporting business objectives. • Oversaw the implementation of Operational Data Stores, Enterprise Lake House, and Business Intelligence solutions, driving actionable insights. • Achieved a 30% savings on storage with improved query performance through automated data life cycle management. • Spearheaded the integration of advanced data visualization tools, enhancing user accessibility and decision-making capabilities. • Implemented robust data quality frameworks, ensuring the accuracy and reliability of information across all systems. • Orchestrated cross-functional collaboration between engineering, product, and business teams, fostering innovation and accelerating project delivery timelines.
Principal Database/Systems Architect
2018 - 2020
• Designed and managed multi-tenant multi-cloud data clusters, focusing on high availability, reliability, and scalability. • Improved database clusters' efficiency by 50% during loading customer heap dump files, optimizing data structure representations. • Implemented and tested ransomware recovery procedures, ensuring data integrity and security. • Successfully led the migration of customer data from private data centers to public cloud systems, achieving data integrity with zero customer issues and seamlessly cutting over customers to cloud systems. • Spearheaded the development of a data governance framework, streamlining data management processes and ensuring compliance with regulatory standards. • Initiated and led cross-functional initiatives to enhance data security measures, resulting in a significant reduction in cybersecurity threats and vulnerabilities. • Established best practices for data lifecycle management, including data retention policies and archival strategies, optimizing storage utilization and performance.
Principal Database Architect
2015 - 2018
• Led a team in Agile environments to build core business applications in multi-cloud data centers. • Designed and deployed multi-site, multi-tenant distributed SQL and NoSQL data clusters across various AWS regions. • Implemented a data governance framework using the Collibra data intelligence tool. • Spearheaded the development of real-time data processing pipelines, enabling timely insights and decision-making. • Championed the adoption of advanced analytics techniques, including machine learning algorithms, to extract actionable insights from data. • Orchestrated the integration of disparate data sources, ensuring data consistency and accuracy across the organization. • Collaborated with cross-functional teams to define and implement data-driven solutions aligned with business objectives. • Actively participated in industry conferences and seminars, sharing insights and best practices in data management and analytics.
Sr. Database Engineer (PostgreSQL, MySQL, MongoDB, ElasticSearch)
2013 - 2015
Working in a fast growing start up culture Agile Methodology environment using the great tools like SVN, JIRA, Nagios, Puppet, AppDynamics, SalesForce, BigData, MongoDB, MMS, SQL 2014, etc. Implemnted SQL Server 2014 AlwaysOn replica sets in synchronous and asynchronous modes, tested the failover, performance metrics Installed, configured, Opitmized and upgraded Sharded clusters, Replica Sets Servers on Windows and Unix 64 bit platform both on On-Prime as well cloud hosted servers (AWS) Setup the DNS Names for MongoC Config Servers & Migrated the Shards between geographic data centers, renamed Config servers, changed the OpLog size of replica set members. Implementing Cloud based Mongo Monitoring Service (MMS), Mongo Backp Agent, MMS Automation Agent service to backup the Sharded Cluster, Replica Sets for Point in time recovery strategies. Also tested the restore plan with 2-factor Authentication. Implemented Mongo replica sets / Tagware sharding cluster Geographically to best fit application performance, reliability and usage. Added / removed nodes from replica sets & shard clusters Geographically. Attended and completed class room training & certification for MongoDB DBA course from 10Gen. Also attended online training and certification "Advanced Operations Training" from MongoDB University. Work on development & implementation of Data Model, application data patterns, queries, collections and documents using JSON and PHP scripts Enabled the Profiler for slow queries, analyzed the profiler data for long running queries, fixed the sub optimal or missed indexes and tuned the query patterns for best response time and latency. Created & Implemented backup / recovery scripts in JSON/java for taking database backup from slave nodes and config servers as part of DR plan Experience in Mongodump, mongorestore, duplicating database, mongoexport, mongoimport, logins, java script execution, adding indexes, creating sub documents, arrays Troubleshooted the problematic queries
Sr. BI / SQL Server DBA
2011 - 2013
Align Technology, Inc. is a global medical-device company that pioneered the invisible-orthodontics, Invisalign system, a clear,orthodontic-treatment option for straightening teeth. Responsibilities:- •Worked on Incident and Change Management space supporting Align Live ID applications and databases for both Production and Integration environment •Implementing Snapmirror, Snapvault, backups, creating and managing the disks through Snap Drive. •Analyzing usage of Disk I/O, CPU, Memory, and space utilization on instance level, Imported data from text files and excel spread sheets into SQL Server 2008 database using SSIS package •Managed 100 + IIS webservers and 500 + SQL Servers including patching and software upgrades,Setting replication/Log shipping and high availability solutions for various client applications •Providing Design, Architecture & Engineering support as well as on-call support for SQL Server databases and servers using SQL Server 2000, 2005 and 2008 •Performing DB backups, restores ,clean-up & DB maintenance activities in a large like fragmentation / re-indexing, log file monitoring, statistics update, integrity checks, performance tuning, disaster recovery & cross group collaboration •Plan and design new SQL Server implementations, server-to-server migrations, and upgrades, including database definition, structure, documentation, and long-term hardware and storage requirements. •Designing storage strategies (ISCSI/SAN/NETAPP) and establish standards for complex database environments, physical structures, and specialized database applications. •Extensively worked on logical and physical database design, performance, scalability and tuning reviews/assessments (DB and SQL tuning), and query monitoring. •Responsible for troubleshooting database performance and implementation problems, identifying and planning resource needs like disk space, memory and processors and monitor CPU usage and resolving blocking and dead locks.
Sr. SQL Server DBA Lead / Oracle DBA
2010 - 2011
Intuitive Surgical is the global leader in the rapidly emerging field of robotic-assisted minimally invasive surgery. The company is providing technology and procedural innovation across cardiac, urology, gynecologic, pediatric and general surgical disciplines through da Vinci System shipment. Being a part of IT Services & Support team, I will support & monitor all production & pre-production robotic live SQL Server & Oracle application databases. Responsibilities: • Providing Design, Architecture & Engineering support as well as on-call support for SQL Server databases and servers using SQL Server 2000, 2005 and 2008 • Plan and design new SQL Server implementations, server-to-server migrations, and upgrades, including database definition, structure, documentation, and long-term hardware and storage requirements. • Providing standardization and consistency across environments, Design, implement, and monitor database functionality to ensure stable environments. • Designing storage strategies (ISCSI/SAN/NETAPP) and establish standards for complex database environments, physical structures, and specialized database applications. • Extensively worked on logical and physical database design, performance, scalability and tuning reviews/assessments (DB and SQL tuning), and query monitoring. • Regularly monitoring backup & restore jobs, refreshing test databases from production, deploying new applications, datacenter migrations, SSIS package creations, report generations. • Created & monitoring 3-node 6-instance Active-Active SQL 2008 cluster nodes on Win 2008 R2 servers, applying patches, updating service packs, hot add on memory & CPU upgrades. • Advanced level experience with DTS, SSIS packages, T-SQL, SQL Reporting Services (SSRS), stored procedures, triggers, cursors, constraints, views, and power shell • Implemented server and database auditing through the use of server side tracing, server audit specifications, and event notifications
Senior SQL Server Production Support / Performance Tuning DBA
2010 - 2010
• Supporting Intuit’s ESTORE & LIGHTYEAR Live EASM (Enterprise Application System Management ) Data SQL Production / Pre-production Database Applications and provide software build support & ongoing assistance with build activities to ensure timely delivery of testing, production software builds in a highly software development life cycle process & creation of cross-functional flow charts as part of Reverse Engineering • Maintaining production, pre-production servers, applying patches and service packs, upgrades, refreshing test boxes from production backups, restoring databases for other teams whenever required in preparing their environment • Performing DB backups, restores ,clean-up & DB maintenance activities in a large like fragmentation / re-indexing, log file monitoring, statistics update, integrity checks, performance tuning, disaster recovery & cross group collaboration. • Review designs and SQL code from fellow developers to ensure adherence to established coding principles & standards and also to support development objectives. • Designing database schema, data insertions and retrievals, procedures, triggers, scripts and queries with abilities to prioritize and operate proactively. • Troubleshooting and resolving complex technical issues including performance tuning stored procedures / queries, triggers, views & functions on a large OLTP DB’s with high transaction rates & concurrency, automation with jobs, monitoring database exports, table spaces, and extent reports. • Responsible for design, setup, installation, and implementation of DB’s, data maintenance (re-indexing, integrity checks, statistics update, log file monitoring), performance tuning ( fragmentation, compression drive distribution, load balancing, replication), technical documentation and implementation of SQL Server disaster recovery models • Adding servers to IDERA Diagnostic Monitoring tool, Configuring alerts through Idera for all production boxes and regular monitoring.
Senior Production Support SQL Server DBA
2009 - 2010
Performing DB backups, restores ,clean-up & DB maintenance activities in a large like fragmentation / re-indexing, log file monitoring, statistics update, integrity checks, performance tuning, disaster recovery & cross group collaboration. Troubleshooting and resolving complex technical issues including performance tuning stored procedures / queries, triggers, views & function on very large OLTP DB’s with high transaction rates & concurrency. Automation with jobs, importing & exporting data from production to QA/DEV boxes, table space issues monitoring & extent reports handling. Performing security management by maintaining roles, giving privileges to user profiles, working & editing with batch files or shell scripts. Provide software build support & ongoing assistance with build activities to ensure timely delivery of testing & production software builds in a highly dynamic software development life cycle process. Review designs and SQL code from fellow developers to ensure adherence to established coding principles & standards and also to support development objectives. Working with cross database environment like ORACLE/UNIX to drive product fixes & analyzing overall systems workload, performance & functionality •Checked performance tuning, indexing and query optimization & Responsible for proper indexing on columns of tables and memory management to invoke faster query results •Perform Database tuning or DETA tasks for trouble tickets pertaining to access issues or connectivity issues within the database or database jobs that are running according to their defined schedules •Troubleshooting application and performance issues using SQL Profiler & Monitors key statistics and metrics for production databases using DBCC commands •Supported large database, 600GB-800GB in production environment •Attending daily triage meeting for updates and provide 24X7 support •Working on Live site deployments and patching for different clouds.
SQL Server Production & Developer DBA
2005 - 2009
Worked as MS SQL Server Production Support Database Administrator for Live Mission Critical Terabyte Databases and Application Support/Monitoring.Proven abilities to direct and troubleshoot, database administration and network administration. Expert with SQL Server 2000/2005/2008, Windows 2003/2008 and: SQL Server Internals, Database fundamentals, RDBMS concepts, Performance Tuning and Optimization techniques. Physical database design, Development, Performance Tuning (with Profiler) and Query optimization (with Show Plan) User Management, Security, Backup and Recovery Well versed in implementing and administering Windows NT4/2003(Active Directory), SQL Server 2000/2005 and internetworking with TCP/IP. Design and Development of highly scalable, efficient and secure SQL Server systems OLTP technologies such as SQL Server Clustering, Mirroring, Log Shipping and Replication for High Availability and Disaster recovery OLAP/Data Warehousing concepts and technologies such as ETL, DTS/BCP, SQL Server Analysis Services, Integration Services and Reporting Services Expert knowledge and applied experience in performance monitoring, remote administration, client/server architecture, Web application management, internet technologies and network architecture. Strong knowledge of DNS, Windows Clustering, Storage Array Networks and Hardware Load Balancing Strong analysis and customer service skills with sound problem solving, judgment and decision-making skills. Strong ITIL and MOF knowledge and experience Knowledge of scripting languages and technologies (Powershell, VBScript, Perl, WMI etc.), Experience with programming (T-SQL, ASP.NET, XML, HTML) is a plus
Education
Master of Technology - MTech
2005 - 2006
BTech
2001 - 2005