Principal Database Administrator

• Aug 2021 - Present

Database Administrator

• Sep 2019 - Jun 2021

- Responsible for performance tuning, configuration changes, and software updates on both physical and virtualized Postgres and SQL database servers, constantly seeking and acting on opportunities for improvement. - Collaborates cross-functionally as well as working independently on tasks such as database creation, schema alterations, capacity planning, performance analysis, and query optimization. - Implement and improve transformations and scripts that facilitate ETL processes using tools such as Pentaho and Microsoft SSIS. - Create, modify, and optimize stored procedures, functions, and views. - Ensures that database software updates are performed within the patch management schedule. - Manages database user access and privileges as well as ensuring that the databases are implemented securely. - Documents and diagrams database configuration and standards, enabling information sharing across the technology teams. - Seeks or improves automation for routine tasks scripting with Open Source technologies such as Bash and Ruby. - Performs backups and recovery testing, ensuring that all databases are backed up using CommVault or other backup software as appropriate to meet backup and Disaster Recovery requirements. - Monitors, reviews, and configures monitoring and analytics solutions to ensure that the databases are proactively maintained and that any issues are detected quickly using existing or augmenting technologies such as Shinken, Pingdom, Pager Duty, and Nagios. Show less

Database Administrator

• Mar 2015 - Sep 2019

Support/Administer the Reporting and Analytics department in AWS cloud. - Administer and maintain reporting database environments hosted in AWS EC2. - Tune and optimize database processes. - Support new initiatives and projects by providing technical expertise and guidelines. - Work with project members to make sure it finishes complete lifecycle project and gets rolled out successfully. - Ensure daily/monthly and yearly ETL jobs completed successfully. - Deploy ETL packages to maintain, update and migrate the data into and from the assets data warehouse database. - Maintain scheduled jobs, schedule and alerts for all ETL jobs. - Upload, manage the contents and to create the linked reports and setting up the security options for the required users to access. - Participating in the Business requirements discussions for the client reports. - Extensive work on tuning the long-running SQL Stored Procedures. - Involved in providing the break-fix, for the packages and reports that fail to run on production environment. - Learn new methodologies and technologies when needed to reach the goal of coming up with an optimum solution for the various project designs. - Manage work for 3 offshore team consisting of 2-3 members each. Show less

Database Engineer (Consultant)

• Jan 2013 - Feb 2015

Design, develop, install, execute, maintain and optimize ETL tool for oracle databases. • Gather business requirements and document them. • Generate database table designs using target locations. • Create tables in schema with proper indexes and constraints. • Write PL SQL procedure, functions, triggers and packages for the tool. • Install and run the tool to migrate data from source to target. • Document performance issues and optimize them using available technology. Achievements: Reduce load time from days to hours using bulk load design. Streamlined change management for multiple developers. Show less

Senior DBA

• Jul 2011 - Aug 2012

Administer, develop and support various aspects of database and software products and technologies. - Perform basic database administration functions in production and development environments in AWS cloud platform. - Create/modify stored procedures to support changing application needs - Run queries to produce reports for various departments using SQL and SSRS - Architect and implement reporting solutions for various business needs - Work with various departments in an analyst role to translate business needs into technical solutions - Optimize database query performance issues Show less

Database Administrator

• Nov 2006 - Jul 2011

Design, install, monitor, maintain, and performance tune high volume Oracle databases while ensuring high levels of data availability in order to meet company standards. - Create and administer reliable, recoverable and scalable database environments to store and integrate company data in Oracle environments. - Monitor relational databases to optimize database performance, resource use, and physical implementations of databases. - Setup, administer and monitor database replication for reporting and DR purpose. - Monitor and manage database backup and recovery processes, logs and journals to support and ensure data integrity. - Proactively monitor database management systems to anticipate and prevent potential problems. - Analyze system and database failures and execute procedures to restore system and database operations. - Assist in the development of long-term strategic goals for production Oracle databases in conjunction with data owners and department managers. - Control and monitor user access to databases and maintain database security. - Maintain standards and procedures to ensure appropriate use of the database. Show less

Senior DW Analyst

• Dec 2004 - Nov 2006

Administer, maintain and implement proof of concept for potential clients. - Analyze client data, queries. Recommend data partitioning and database table partitioning strategies to maximize performance, based on analysis. - Document partitioning strategies into data model using Erwin. - Alert potential problems and recommend solutions to solve these problems. - ETL terabytes of client data using Shell scripts and in-house tools. - Complex SQL and PL/SQL development for user defined functions. - Tune problem queries using explain plan. - Benchmark data load and query performances to ensure that the timings fall within the expected timeframe. - Client presentations: architecture, demonstration of data load and query run. Address questions and concerns for clients. Show less

Database Administrator

• Dec 2000 - Nov 2004

Administration of on-air television databases, development and maintenance of stored procedures, and monitored in-coming vendor data feed. - Database administration and performance tuning for production databases. - Design scalable logical and physical databases. - Intricate PL/SQL development, tuning and troubleshooting for market data systems including stored procedures, triggers, functions and packages. - Ensure that adequate recovery procedures are in place (database backup and import/export of data). - Experience loading and transforming data using SQL*Loader - Developed Cron jobs and shell scripts for data maintenance and monitoring. - Structured system monitoring and support using Sitescope tool. - Managed onsite and offshore projects. Distributed assignments and scheduled projects for team members. - Extensive exposure with the stock market, futures market, treasuries, market indexes, foreign currencies, and indexes Show less

Database Administrator

• 1999 - 2000