Description :

1. Designed and implemented database solutions to support business applications, enhancing data accessibility and performance.
2. Conducted thorough PL/SQL code reviews, ensuring adherence to best practices and optimizing existing code.
3. Developed custom stored procedures and functions to automate data processing tasks, improving efficiency.
4. Collaborated with cross-functional teams to gather requirements and translate them into technical specifications.
5. Utilized SQL Loader for bulk data uploads, streamlining data migration from legacy systems.
6. Created and maintained comprehensive documentation for database structures and processes, facilitating knowledge transfer.
7. Provided production support, troubleshooting issues, and implementing solutions to minimize downtime.

Experience

7-10 Years

Level

Management

Education

MSc CS

Description :

1. Designed and implemented database solutions to meet diverse application needs.
2. Led the development of a comprehensive database architecture for multiple environments.
3. Collaborated with stakeholders to gather requirements and ensure alignment with business goals.
4. Created and optimized complex SQL queries, stored procedures, and functions for data retrieval.
5. Developed ETL processes to integrate data from various sources into SQL Server.
6. Utilized monitoring tools to identify and resolve performance bottlenecks in database operations.
7. Provided technical support and training to junior developers, enhancing team productivity.

Experience

2-5 Years

Level

Junior

Education

BSc CS

Description :

1. Developed and optimized SSIS packages for efficient data extraction, transformation, and loading.
2. Created complex SQL queries to automate data profiling and ensure data quality.
3. Scheduled and monitored cube processing using SQL Server Agent for timely data availability.
4. Wrote MDX queries for BI applications, enhancing data visualization and reporting.
5. Generated comprehensive reports using SSRS from OLTP and OLAP sources, improving decision-making.
6. Designed interactive reports with drill-down features, enhancing user experience and data insights.
7. Implemented report subscriptions and snapshots to streamline report distribution and performance.

Experience

2-5 Years

Level

Junior

Education

BSc CS

Description :

1. Developed and maintained complex database systems, ensuring high performance and reliability.
2. Designed and implemented data models and schemas to support business requirements.
3. Optimized SQL queries and PL/SQL procedures for improved performance and efficiency.
4. Collaborated with cross-functional teams to gather requirements and deliver database solutions.
5. Automated data migration processes, reducing manual effort and errors.
6. Created and maintained documentation for database architecture and processes.
7. Provided training and support to junior developers on database best practices.

Experience

5-7 Years

Level

Senior

Education

MSc CS

Description :

1. Leveraged cloud architectures to enhance database performance and scalability.
2. Architected and re-architected applications for cloud-native environments.
3. Developed and optimized applications using NoSQL technologies, particularly MongoDB.
4. Executed ad-hoc queries and real-time data aggregation to support business needs.
5. Managed data migration from Oracle to MongoDB, ensuring data integrity and performance.
6. Created and modified PL/SQL procedures, functions, and packages to meet business requirements.
7. Designed and implemented database objects including stored procedures, triggers, and cursors.

Experience

7-10 Years

Level

Management

Education

MSc CS

Description :

1. Designed and implemented scalable database solutions for over 70 clients, enhancing data management.
2. Served as the lead developer for complex database projects, ensuring high-quality deliverables.
3. Executed the first successful integration with Quest Diagnostics for order processing and results.
4. Developed custom functions for parsing and processing data, improving operational efficiency.
5. Created modules for dynamic question libraries, streamlining data entry processes.
6. Reviewed and updated HL7 specifications for seamless data exchange between systems.
7. Implemented a barcoding system that improved record retrieval and navigation for users.

Experience

10+ Years

Level

Consultant

Education

BSc CS

Description :

1. Designed and maintained robust database systems across development, testing, and production environments.
2. Created and deployed SSRS reports from diverse data sources, enhancing decision-making.
3. Developed T-SQL queries and stored procedures for efficient CRUD and ETL operations.
4. Implemented a BI360 data warehouse, providing a unified reporting source for multi-company financial data.
5. Upgraded SQL Server from 2008 R2 to 2014, ensuring compatibility and performance improvements.
6. Managed data migration projects, executing mass updates on hundreds of thousands of records.
7. Converted stored procedures for SSRS reports, improving integration with Dynamics CRM.

Experience

10+ Years

Level

Consultant

Education

BSc CS

Description :

1. Collaborated in an agile environment, participating in daily scrums to enhance project delivery.
2. Designed and developed ETL packages using SSIS for efficient data integration and transformation.
3. Created stored procedures, functions, and views in SQL Server to support reporting and data warehousing.
4. Enhanced database performance through indexing, query optimization, and data normalization.
5. Utilized PowerShell scripting to automate database tasks and streamline development processes.
6. Developed interactive reports using SSRS, providing stakeholders with actionable insights.
7. Coordinated with DBAs to deploy SSIS packages, ensuring smooth integration into production environments.

Experience

2-5 Years

Level

Junior

Education

BSc CS

Description :

1. Provided technical support for database creation and maintenance in Microsoft SQL Server, enhancing performance and troubleshooting issues.
2. Developed and optimized T-SQL code, including stored procedures, functions, and triggers to ensure data integrity.
3. Designed and implemented database security solutions for sensitive financial and personal data.
4. Utilized SQL Server Data Tools to create customized reports, improving data accessibility for stakeholders.
5. Built and managed SSIS packages for ETL processes, ensuring efficient data extraction and transformation.
6. Scheduled and automated reports for various business needs, enhancing decision-making processes.
7. Collaborated with development teams to integrate database solutions into applications, improving overall system performance.

Experience

7-10 Years

Level

Senior

Education

MSc CS

Description :

1. Led the design and implementation of database solutions using Oracle SQL and PL/SQL, enhancing data retrieval efficiency.
2. Conducted thorough code testing and quality assurance, ensuring compliance with TDD practices and delivering robust applications.
3. Collaborated with cross-functional teams to gather and analyze functional requirements, translating them into technical specifications.
4. Managed data migration projects, successfully transferring critical data from legacy systems to modern databases.
5. Created and maintained database objects, including tables, views, and stored procedures, to support application functionality.
6. Documented processes and provided training to team members, fostering knowledge sharing and best practices.
7. Implemented backup and recovery strategies, ensuring data integrity and availability in production environments.

Experience

5-7 Years

Level

Executive

Education

BSc CS

Description :

1. Responsible for all aspects of projects from gathering requirements, designing, coding, testing, documenting, implementing, training, support, and maintenance of applications.
2. Wrote stored procedures, views, triggers and functions in support of the applications.
3. Designed DTS packages to integrate and transform data from various source into SQL Server databases.
   
4. Responsible for backup/recovery, data integrity, and database maintenance and good health plans.
5. Ensured database consistency.
6. Monitored database growth and capacity planning.
7. Worked with tools like SQL Server Dashboard, SQL Profiler and Activity Monitor for event monitoring and performance monitoring, and make recommendations based on the results.

Experience

7-10 Years

Level

Management

Education

B.S. In Computer Science

Description :

1. Aligned data standards and concurrency models, and database configurations for product and ad-hoc projects; created database objects in Oracle, DB2, and SQL Server aligned with technical specifications.
2. Worked with the architecture group on data architecture topics, new database paradigms, and data access mechanisms; optimized, tuned, and implemented data models on multiple DBMS platforms.
3. Performed ETL operations on external tables, databases, and systems; modified existing Java programs for testing/enhancement.
4. Provided advice and guidance to Agile members on population and how to maintain the Jira burndown chart.
5. Completed sprint retrospectives, reviews, and planning sessions.
6. Evaluated hardware/software to support ever-increasing computational and data loads; recommending solutions.
7. Evaluated and implemented the Trader Desktop and offered applicable advice to executives for purchase recommendations.
8. Managed, educated, and mentored global programmers.
9. Analyzed and diagnosed database issues from services and customer support groups.

Experience

7-10 Years

Level

Management

Education

Liberal Arts

Description :

1. Provided consumer financing options for merchants and service providers, specializing in the underserved sub-prime credit segments.
2. Sophisticated analytics that helps partners better understand their customers and their business.
3. Designed and modeled database structure to support business needs using ER/Studio.
4. Developed and supported web financial systems using MS SQL Server and T-SQL coding.
5. Maintained successfully windows applications programming in C# as needed.
6. Developed SSIS packages to export and import data across environments with different business logic.
7. Created stored procedure, indexes, and views using complex queries and scripting.
8. Involved in critical database releases to testing, staging, and production environments.
9. Used SQL Profiler to troubleshoot issues and for query optimization.

Experience

7-10 Years

Level

Management

Education

Master Of Science