Database Analyst
Jacobson's Direct Marketing Services LLC
Total years of experience :13 years, 4 Months
Create etl process, analyze data, create reports and visualisations, maintain database performance, etc
• Installation, Configuration and Maintenance of several Oracle Enterprise and standard edition database
• 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 40 (MS-SQL) production/development servers involving tasks such as backup, synchronization, space management, user management, etc.
• Monitoring server pools with Oracle EM cloud control 12c along with several 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 automation 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/MS-SQL 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 database development team to enhance PL/SQL codes for better performance
• Installation, Configuration and Maintenance of several Oracle Enterprise and standard edition database
• 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 40 (MS-SQL) production/development servers involving tasks such as backup, synchronization, space management, user management, etc.
• Monitoring server pools with Oracle EM cloud control 12c along with several 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 automation 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/MS-SQL 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 database development team to enhance PL/SQL codes for better performance
• 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.
• Experience in Client-Server application development using oracle 12c/11g/10g/9i/8i, PL/SQL, MS-SQL, T-SQL, SQL*PLUS and SQL*LOADER.
• Strong experience in Data warehouse concepts, ETL
• Good knowledge on logical and physical data modeling using normalizing techniques.
• Created packages and procedures to automatically drop schema objects such as indexes, tables, synonyms, views etc and re-create them as per need.
• Created several Shell scripts for invoking SQL scripts and scheduled them using crontab for the purpose of automation as well as monitoring purposes.
• Involved in all phases of the SDLC from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Effectively made use of table functions, indexes, table partitioning, collections, analytics functions, materialized views, query re-write and transportable table spaces.
• Strong experience in Data warehouse concepts, ETL
• Developed materialized views for data replication in distributed environments.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution plans and indexes.
• Experience with Performance tuning for Oracle RDBMS using explain plans, HINTS and CBO
• Experience in ETL techniques and analysis and reporting.
(2005-2010) H.S.E.B +2 Science (Higher Secondary Education Board-TWO Years) Janata Model H. S. S.
Passed in First Division (2005-2010) @ 71.2% C.G.P.A – 3.28 (with a 3.6 in 5th semester and 3.71 in 6th semester) Enrolled under the PSTFC (Partially Subsidized Tuition Fee Scheme) Scholarship granted by the Purbanchal University Scholarship Program for the Science and Technology program