Subhan Singh Karki

Experience

• 

  Verscend

  Oct 2010 - Jan 2016

  • Installation, configuration and maintenance of several instances of Oracle enterprise edition database for both development and production purposes• Installation, Configuration and Maintenance of several instances of MS-SQL database for both development and production purposes.• Continuous support to both Production and Development Team.• Responsible for over 50 (Oracle) and over 50 (MS-SQL) production/development servers involving tasks such as backup, synchronization, space management, user management, etc.• Configuration, Maintenance and continuous R&D on Oracle OEM Cloud Control 12c and monitoring server server pools with Oracle EM cloud control 12c along with multiple regular/maintenance tasks• Security implementation in both OS and Database level of production servers ensuring several standard policies (HIPAA, PHI)• Involvement in Development of Reporting tools for current/future analysis.• Development of automate script as per Easiness and Business need.• Research and development on Heterogeneous Database connectivity (Oracle, MS-SQL, Vertica, etc)• Daily DB health check• 24x7 support• Monitor performance and tune database parameters• Work with Oracle support for bugs and workout solutions to be implemented• Apply PSU/CPU patches for Linux/windows machines with Oracle installed as well as updating SQL Server database to latest stable releases• Deploy new codes in Production environment and synchronize master schemas across all production servers (more than 50)• Continuously work with development team to enhance codes for better performance Show less • Installation, configuration and maintenance of several instances of Oracle enterprise edition database for both development and production purposes• Installation, Configuration and Maintenance of several instances of MS-SQL database for both development and production purposes.• Continuous support to both Production and Development Team.• Responsible for over 50 (Oracle) and over 50 (MS-SQL) production/development servers involving tasks such as backup, synchronization, space management, user management, etc.• Configuration, Maintenance and continuous R&D on Oracle OEM Cloud Control 12c and monitoring server server pools with Oracle EM cloud control 12c along with multiple regular/maintenance tasks• Security implementation in both OS and Database level of production servers ensuring several standard policies (HIPAA, PHI)• Involvement in Development of Reporting tools for current/future analysis.• Development of automate script as per Easiness and Business need.• Research and development on Heterogeneous Database connectivity (Oracle, MS-SQL, Vertica, etc)• Daily DB health check• 24x7 support• Monitor performance and tune database parameters• Work with Oracle support for bugs and workout solutions to be implemented• Apply PSU/CPU patches• Deploy new codes in Production environment and synchronize master schemas across all production servers (more than 50)• Continuously work with development team to enhance codes for better performance Show less • Over 3 and half years of programming experience as an Oracle PL/SQL and T-SQL developer in Analysis, Design and Implementation of Business Application using the Oracle.• Involved in all phases of the SDLC from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.• Strong experience in Data warehouse concepts, ETL• Good knowledge on logical and physical data modeling using normalizing techniques.• Developed materialized views for data replication in distributed environments.• Created packages and procedures to automatically drop schema objects such as indexes, tables, synonyms, views etc and re-create them as per need.• Good knowledge of key performance related features such as Query Optimizer, Execution plans and indexes.• Experience in ETL techniques and analysis and reporting.• Created several Shell scripts for invoking SQL scripts and scheduled them using crontab for the purpose of automation as well as monitoring purposes. Show less • Involved in all phases of the SDLC from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.• Good knowledge on logical and physical data modeling using normalizing techniques.• Developed materialized views for data replication in distributed environments.• Created packages and procedures to automatically drop schema objects such as indexes, tables, synonyms, views etc and re-create them as per need.• Experience with Performance tuning for Oracle RDBMS using explain plans, HINTS and CBO• Experience in ETL techniques and analysis and reporting.• Created several Shell scripts for invoking SQL scripts and scheduled them using crontab for the purpose of automation as well as monitoring purposes. Show less

  • Senior Database Administrator

    Mar 2015 - Jan 2016

  • Database Administrator

    Jul 2013 - Mar 2015

  • Software Engineer

    Oct 2011 - Jun 2013

  • Associate Software Engineer

    Oct 2010 - Sept 2011
• 

  Jacobsons Direct

  May 2016 - Jul 2020

  Database Analyst

  • Responsible for monitoring and maintaining the performance standard of the database server as well as its integrity• Used various BI Tools to create interactive reports for the purpose of business deliverable as well as in-house reporting • Developed programs in Python, scraping data from the web, cleaning it and storing it in the database for further data mining and analysis purpose• Used Python to create data pipelines, while working with heterogenous data sources and API's, followed by data cleansing and aggregation, and finally reporting and information dissemination in a scheduled and automated workflow• Point on digital marketing platforms such as Hubspot (Certified), Google Adwords (Certified), Facebook Ads, etc.• Constant R&D on technologies/platforms to give an insight as to what can be achieved and how it can add to the business profile Show less

• 

  Devfinity

  Mar 2021 - now

  Spearhead and oversee the entire data department, leading a team of skilled data analysts, database administrators, and data engineers.Develop and implement data strategies, aligning them with organizational objectives to enhance efficiency and drive innovation.Identify key performance indicators (KPIs) and implement data tracking mechanisms to measure and report on data-related metrics for continuous improvement.Collaborate with cross-functional teams to establish data governance policies, ensuring data quality, privacy, and security across the organization.Successfully managed data projects, ensuring timely delivery and adherence to budgetary constraints. Show less

  • Manager data

    Jan 2022 - now

  • Senior Data Engineer

    Mar 2021 - Dec 2021