FIND PERSONALIZED JOBS
Sign up to Zippia and discover your career options with your personalized career search.
Sorry, we can't find that. Please try a different city or state.

Senior Database Developer

This job has expired and is no longer available.
APPLY NOW
Apply Now
×
FIND
PERSONALIZED JOBS

Sorry, we can't find that. Please try a different city or state.

CONTENT HAS
BEEN UNLOCKED
Close this window to view unlocked content
or
find interesting jobs in

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign Up

SIGN UP TO UNLOCK CONTENT

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Forgot Password?

Don't have an account? Sign Up

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Log In

Log In to Save

Sign Up to Save

Sign Up to Dismiss

Sign up to save the job and get personalized job recommendations.

Sign up to dismiss the job and get personalized job recommendations.

or

The email and password you specified are invalid. Please, try again.

Email and password are mandatory

Already have an account? Log in

reset password

Enter your email address and we will send you a link to reset your password.

Back to Log In

Company Saved

Answer a few questions and view jobs at that match your preferences.

Where do you want to work?

Job Saved

See your Saved Jobs now

or

find more interesting jobs in

Job Dismissed

Find better matching jobs in

Your search has been saved!

Top 50 Senior Database Developer Skills

Below we've compiled a list of the most important skills for a Senior Database Developer. We ranked the top skills based on the percentage of Senior Database Developer resumes they appeared on. For example, 12.9% of Senior Database Developer resumes contained Pl/Sql as a skill. Let's find out what skills a Senior Database Developer actually needs in order to be successful in the workplace.

These are the most important skills for a Senior Database Developer:

1. Pl/Sql

demand arrow
high Demand
Here's how Pl/Sql is used in Senior Database Developer jobs:
  • Developed Stored Procedures, Packages, Triggers and Views using relational database technology (Oracle), SQL, PL/SQL programming.
  • Fine-tuned PL/SQL Procedures, SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization.
  • Designed Data Warehousing environment and using PL/SQL developed process to extract, transform and load data from source applications.
  • Coded PL/SQL sub-programs and modified the existing PL/SQL program units for customer Contact Employees (CCE's) relationships.
  • Developed PL/SQL-Packages, Procedures, Functions, SQL Scripts and Database Triggers to populate the historic data.
  • Implemented database changes using complex SQL queries, Dynamic SQL, Parallel DML's and PL/SQL subprograms.
  • Designed physical data models and developed PL/SQL packages to support the Order Service and Product Catalog applications.
  • Conduct advanced programming activities related but not limited to Randomization, Normlab2, and PL/SQL scripting.
  • Designed and developed advanced SQL and PL/SQL packages, procedures, and UNIX scripts.
  • Involved in database development by creating PL/SQL functions, procedures, triggers, packages.
  • Used PL/SQL and SQL*Loader calling UNIX scripts to upload and manipulate data into database.
  • Review and tune PL/SQL, stored procedures and views for performance and accuracy.
  • Modified Oracle Forms 6I and related client, back end PL/SQL packages.
  • Developed and modified PL/SQL packages, functions, procedures, triggers.
  • Created triggers, stored procedures, functions & cursors in PL/SQL.
  • Create PL/SQL packages, standalone procedures, and standalone functions.
  • Developed PL/SQL Procedures, Functions, Cursors, and Packages.
  • Created Object libraries, PL/SQL libraries and template Forms.
  • Code the APIs in PL/SQL from the command line using SQL Plus.
  • Developed Oracle database components in PL/SQL for Openwave's next generation Analytics products.

Show More

2. SQL

demand arrow
high Demand
Here's how SQL is used in Senior Database Developer jobs:
  • Created a table-driven/rules-driven SQL data validation application used to identify data outside of predefined acceptable ranges.
  • Developed PL/SQL programs which manipulated data to/from Oracle 11g Database using PL/SQL for Sony Entertainment's Royalty Management system TEMPO.
  • Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
  • Developed Batch processes in UNIX shell scripts for processing of business needs by using of PL/SQL and SQL.
  • Involved in performance tuning of SQL queries by using explain plan and oracle hints (occasionally).
  • Created stored procedures using SQL Server 2012 to automated time and expense reporting for accounting department.
  • Developed SQL scripts, packages and procedures for Business rules check to implement business rules.
  • Involved in Database management like partitioning, SQL tuning and Database performance activities.
  • Write SQL loader script to load flat file data into staging table.
  • Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
  • Upgraded to SQL 2014, created scripts to install local development environments.
  • Offer database administration and support on production and test SQL servers.
  • Used SQL*Loader to load bulk data from various flat files.
  • Create reports utilizing excel macros and SQL server tables.
  • Develop reports using SQL, PL/SQL.
  • Performed SQL and PL/SQL tuning and Application tuning using EXPLAIN PLAN, SQL*TRACE, TKPROF, AUTOTRACE and AWR report.
  • Work on changes using SQL and Unix.
  • Enhanced existing PL/SQL (Stored procedures, packages, functions and Triggers) Worked on PL/SQL functions, packages and processes.
  • Involved in backend database testing using SQL.
  • Develop back end processes in Oracle PL/SQL using Apache mod_plsql module for creation of html web pages.

Show More

29 SQL Jobs

No jobs at selected location

3. Database

demand arrow
high Demand
Here's how Database is used in Senior Database Developer jobs:
  • Design, develop and support database solution for product portfolio management system.
  • Optimize query performance by designing suitable projections using Database Designer.
  • Constructed entire database program allowing the company to examine and determine their profits for each of their products and customers worldwide.
  • Developed SQL scripts for Referential Integrity check, which checks validity of incoming data with master tables in database.
  • Created databases per design document, created tables, views, stored procedures and functions per technical specification.
  • Create and manage Oracle database on amazon cloud using AWS relational data service (RDS).
  • Designed and created a SQL Server 2008 database for a Medical Letter App using ERWIN.
  • Created Indexes for faster retrieval of the customer information and enhance the database performance.
  • Implemented audit triggers on tables to control user account access to the database.
  • Developed SQL scripts to create database objects like tables, views and sequences.
  • Developed and maintained procedures, tables and views on multiple servers and databases.
  • Designed and developed databases that collected, tracked, and reported data.
  • Developed SQL and PL/ SQL scripts for migration of data between databases.
  • Managed over 100 databases across 30+ servers in development environment.
  • Design, Develop and Implement Oracle Database Solutions.
  • Create custom database reports: MS-Access, MS-Word, MS-Excel (tablular and PivotTables), RightFax.
  • Implemented codebase to support multiple databases for various clients.
  • Develop security , roles and permission , matrix needed for new database solutions.
  • Manage databases configuration parameters and resource pool settings Load large datasets into Vertica database using COPY command.
  • Lead in requirement gathering , develop technical specifications, database design , coding , unit test, and user acceptance test.

Show More

34 Database Jobs

No jobs at selected location

4. Data Warehouse

demand arrow
high Demand
Here's how Data Warehouse is used in Senior Database Developer jobs:
  • Created TSQL scripts to automate the loading of configuration data for multiple extract files into the new Data Warehouse.
  • Created OLAP cubes on top of data warehouse based on facts and dimension tables for analysis purposes using SSAS.
  • Assisted in building a reporting Data Warehouse for EPIC Electronic Health Record data, from multiple hospitals and clinics.
  • Work with enterprise data warehouse team to ensure data properly loaded from and into the data warehouse system.
  • Use all aspects of ETL to get diverse data from multiple sources into SQL Server data warehouse.
  • Participated in the Architecture of Global Data Warehouse (GDW) project from early development stage.
  • Provided data population and validation, performance tuning, system deployment, and data warehouse maintenance.
  • Troubleshooted and optimized SQL Server 2012 Data Warehouse for Sage 500 ERP and other apps.
  • Involved in creation of Data warehouse Cubes in SQL Server Analysis Service (SSAS).
  • Load upstream data files into the data warehouse and generate the downstream data files.
  • Create complex stored procedures for use in reporting off of data warehouse.
  • Migrated the CMSI B2B/B2C applications into new Data Warehouse methodology.
  • Loaded Data into ESP Data warehouse from 28 different sources.
  • Created data marts and data warehouse using MSBI tools.
  • Designed and built physical data warehouses.
  • Experience with large databases Created DTS packages and scheduled jobs to load data files from different formats into Data Warehouse.
  • Implemented, deployed, and maintained three separate production Sybase IQ data warehouse environments totaling over 200TB of storage.
  • Provided engineering, development and operational support for Openwave's Data Warehouse Analytics products.
  • Architected, developed, and proposed appropriate solutions where the companys data warehouse solution was failing.
  • Designed and developed the Data Warehouse for Openwave's Amplicity platform for browser-based apps analytics.

Show More

6 Data Warehouse Jobs

No jobs at selected location

5. ETL

demand arrow
high Demand
Here's how ETL is used in Senior Database Developer jobs:
  • Created custom ETL tools using C# to import data from hundreds of heterogeneous Excel documents (Visual Studio 2013).
  • Involved in Design, analysis, Implementation, Testing and support of ETL processes for Stage, ODS and Mart.
  • Developed ETL process to pull the data from client's database into OLAP database and process the cube using SSIS.
  • Create SQL queries for Third-Party Benefits Data Mart, ETL, and optimize edits, formats, and performance.
  • Used PL/SQL and SQL*Loader to create ETL packages for flat file loading and error capturing in log tables.
  • Performed ETL operations on external tables, databases, and systems; modified existing Java programs for testing/enhancement.
  • Used PL/SQL and SQL*Loader to create ETL packages to load external vendors flat files into client databases.
  • Created XML layout files used by the ETL system to load files into multiple Oracle 10g databases.
  • Developed the custom ETL logic used in the zero downtime launch of multiple sites to AWS.
  • Developed data extract, transformation, and loading (ETL) processes.
  • Involved in ETL process under development, testing and production support environments.
  • Used ETL to load data from various systems into staging tables.
  • Established the ETL infrastructure, ETL/DW standards and ETL naming conventions.
  • Designed and developed SQL Server 2008 SSIS ETL Packages.
  • Resolved various performance issues in ETL and Database issues.
  • Involved in creation of ETL standards documentation.
  • Post ETL Dynamic URI Updates.
  • Used ETL methodology for supporting data extraction, transformations and loading processing, using Informatica.
  • Developed Informatica Cloud Processes for ETL.
  • Used Informatica designer, monitor and workflow manager extensively for ETL development and support activities.

Show More

6 ETL Jobs

No jobs at selected location

Job type you want
Full Time
Part Time
Internship
Temporary

6. Ssis

demand arrow
high Demand
Here's how Ssis is used in Senior Database Developer jobs:
  • Created SSIS packages to Oracle and other SQL Server instances and used configuration files and variables for production deployment.
  • Created SSIS packages and SQL agent jobs to import costs, marketing, funnel, and website usage data.
  • Conducted comprehensive unit testing and also assisted the QA team by finding problems with their test cases.
  • Created multiple ETL and SSIS packages for data feed and data transfer between databases and servers.
  • Created new SSIS packages for the Business Intelligence group for a major health care service corporation.
  • Used SSIS projects to process and import external data into application databases.
  • Collect the business requirement and deliver the financial reports with SSIS.
  • Lead developer in rewriting SAP Data Services ETL jobs to SSIS.
  • Automated daily client data feeds from FTP via SSIS.
  • Created complex stored procedures used to support SSIS programming.
  • Scheduled SSIS Packages for loading Facts and Dimensions.
  • Worked with different methods of logging in SSIS.
  • Created packages in SSIS with error handling.
  • Assisted management with various SQL Server projects.
  • Create and deploy SSIS packages.
  • Created SSIS/DTS packages for loading from different data sources (flat files, excel source files, XML files etc.)
  • Experience in creating complex SSIS packages using proper control and data flow elements * Involved in updating slowly changing dimensions strategies.
  • Re-worked on existing SSIS packages with checkpoints for monitoring and logging audit Performed unit testing on modified scripts.
  • Worked on complex stored procedures, triggers, ssis packages and performance tuned existing code.
  • Extract, load and transform the daily/monthly Amdocs transactional data to the Recognized Revenue Model on SQL Server with SSIS.

Show More

8 Ssis Jobs

No jobs at selected location

7. Business Requirements

demand arrow
high Demand
Here's how Business Requirements is used in Senior Database Developer jobs:
  • Worked with internal and external customers to translate business requirements into achievable high quality technological solutions that consistently superseded client expectations.
  • Participated in review meetings to finalize the design and functional documents to support business requirements.
  • Authored all project related documentation including the Business Requirements, Functional Specifications and Data Dictionary.
  • Work with multiple departments on ensuring accurate interpretation of business requirements and application architecture.
  • Scoped client's business requirements and managed on-time and on-budget delivery of solutions.
  • Create Conceptual and Technical Architecture documents for project teams to support business requirements.
  • Worked with business analysts for business requirements, analysis and technical specifications.
  • Collected, documented and translated business requirements into technical specifications.
  • Interacted with the Business Users to analyze the business requirements and transform the business requirements into the technical requirements.
  • Involved in writing Queries, Stored Procedures, functions, Packages to implement the business requirements.
  • Customize, Develop and Maintain Oracle Forms and Reports and Libraries to accommodate new business requirements.
  • Created several Functions, Procedures, Packages and Triggers as per the business requirements.
  • Created materialized views, Inline Views & normal views where business requirements needed.
  • Analyze business requirements to create a database structure for hospital billing data.
  • Defined constraints, rules, indexes and views based on business requirements.
  • Tested the functionality as per the client business requirements.
  • Worked with business owners in order to gather business requirements into technical solutions for creating and executing specific deliverables.
  • Work closely with Business Analysts and Project Managers to ensure that business requirements and timelines are met.
  • Analyze the business requirements from the client and designing the Technical Specification for architect's review.
  • Worked with Subject Matter Experts (SMEs) to gather/clarify business requirements for data and reporting.

Show More

2 Business Requirements Jobs

No jobs at selected location

8. Unix

demand arrow
high Demand
Here's how Unix is used in Senior Database Developer jobs:
  • Manage and support UNIX/Linux existing application
  • Created various UNIX shell scripts for automate process of loading data files from customers to Oracle database using SQL*Loader.
  • Developed batch programs using UNIX shell scripts to generate reports daily, weekly & monthly for Customers Markets.
  • Developed and managed multiple web-enabled projects for the brokerage system using C, UNIX, and Oracle.
  • Implement design changes to stored procedures, packages, UNIX shell scripts and job scheduling.
  • Created UNIX shell scripts and external tables to upload data into database tables for processing.
  • Write UNIX shell scripts for data files handling, FTP and executing the SQL*Loader.
  • Developed and maintained UNIX and Shell scripts for database process and conversions.
  • Provided support to NT developers transitioning to working with Unix and Oracle.
  • Developed UNIX Shell scripts to automate table creation, execute procedures.
  • Worked on high volumes of data under the platform of UNIX/WINDOWS.
  • Worked on UNIX shell scripting for creating automated test scripts.
  • Performed UNIX to Linux O/S Conversions when Linux conversion occurred.
  • Worked on UNIX scripting for scheduling and management of files.
  • Created UNIX Shell scripts for automating the execution process.
  • Involved in creating UNIX shell Scripting.
  • Developed Unix Shell scripts for the various jobs and schedules, Involved in production support for the various applications.
  • Converted extensive ETL processes from Oracle/Unix/SQL*Loader/Cron Scheduling environment to SQL Server, SSIS, JAMS environment.
  • Compile in Linux/UNIX and move them Dev/Source & Test/Source.
  • Batch maintenance is performed through unix and Sql*Plus scripts via crontab scheduling.

Show More

1 Unix Jobs

No jobs at selected location

9. T-Sql

demand arrow
high Demand
Here's how T-Sql is used in Senior Database Developer jobs:
  • Supported development effort by providing T-SQL statement tuning and optimize data loading processes.
  • Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data loads and transformations.
  • Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
  • Created T-SQL queries, tables, Views, stored procedures and functions that are required for report generation.
  • Develop all the required stored procedures, user defined functions, and triggers using T-SQL and PL/SQL.
  • Mentor application and database developers in best practices for database design and writing Transact-SQL queries.
  • Completed database modeling, designing and development using Erwin and wrote Stored Procedures in T-SQL.
  • Developed and supported web financial systems using MS SQL Server 2005 and T-SQL coding.
  • Created automated T-SQL scripts to process summary database transactions that run off-hours.
  • Created various SSIS packages and T-SQL Scripts for integration and reporting purposes.
  • Researched and resolved all production T-SQL related application errors and job failures.
  • Optimized Microsoft SQL Server SQL/T-SQL, stored procedures and DTS packages.
  • Provide database coding to support business applications using SQL server T-SQL.
  • Assist other developers with T-SQL code and query design.
  • Developed complex data loads with SSIS and T-SQL.
  • Optimized existing stored procedures by re-factoring T-SQL code.
  • Developed Complex Procedures, indexes, Partition Schemas, Partition Functions, triggers using T-SQL on Microsoft SQL Server.
  • Worked in maintaining the Product Information (PIM) and Ecommerce (ECom) support using T-SQL.
  • design and develop complex T-SQL ad-hoc scripts, including cleanup and roll back scripts as needed.

Show More

10. Ssrs

demand arrow
high Demand
Here's how Ssrs is used in Senior Database Developer jobs:
  • Developed NORC's proprietary Case Management System Database Data Dictionary using SSRS.
  • Developed multiple reports for Accounting, Marketing, and other departments with the use of SSRS and Microsoft Visual Studio.
  • Created reports as per user requirement using SQL Server reporting services (SSRS) which delivers enterprise and Web-enabled reports.
  • Experience in Developing and Publishing Reports in SQL Server 2005 using SSRS (SQL Server Reporting Services).
  • Worked on SSRS 2005/2000 to generate about 30+ reports for various user groups and developer groups.
  • Used SSRS to create interactive, tabular, matrix, graphical or free from reports.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
  • Designed reports in both SSRS and Tableau to facilitate analysis of client metrics.
  • Create and maintain SSRS reports in Visual Studio 2013 for all above application.
  • Create reports with SSRS with SQL stored procedures for trade reporting applications.
  • Created client designed custom reports and charts using SQL Server 2008 SSRS.
  • Design and development of SSIS and SSRS packages.
  • Developed Financial and Auditing Reports using SSRS.
  • Developed and deployed SSRS reports.
  • Increased company's revenue by implementing multiple decision making dashbords and KPI's via SSRS.
  • Designed complex and custom reports using SSRS with drilldown features, sub reports, charts.
  • Created critical SSRS reports for job monitoring, ticket tracking and workflow.
  • Create Reports with SSRS for monitoring of dataflow.
  • Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports usingSSRS.
  • Created data sources, connection strings and defined the datasets for generating the reports using SSRS.

Show More

1 Ssrs Jobs

No jobs at selected location

11. Toad

demand arrow
high Demand
Here's how Toad is used in Senior Database Developer jobs:
  • Designed logical and physical database models using TOAD Data Modeler.
  • Construct logical and physical designs across multiple databases and provide recommendation, tools used Toad data modeler and MS Access.
  • Created database Tables, Views, Sequences in Development and Production environment using PL/SQL, SQL*Plus, SQL Developer Toad.
  • Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
  • Worked extensively on TOAD to analyze data and fix errors and develop.
  • Used TOAD tool for querying and troubleshooting PL/SQL queries and codes.
  • Used TOAD developer tool for faster application design and developments.
  • Used SQL Navigator and Toad tools for PL/SQL, SQL coding.
  • Performed ad-hoc queries using TOAD for SQL Server.
  • Worked on Oracle 11g, Teradata 13.0, Unix, Eclipse and Toad.
  • Worked on Oracle 11g, Eclipse, Linux.Toad and PL/SQL.
  • Worked on Teradata 15.10, Oracle 12c, Linux, Toad, MS SQL Server, Informatica and PL/SQL.

Show More

1 Toad Jobs

No jobs at selected location

12. XML

demand arrow
high Demand
Here's how XML is used in Senior Database Developer jobs:
  • Developed meta-data structure and configuration for storing/preserving database connection and security parameters using SQL Server configurations, XML configurations.
  • Developed a generic XML specification for data driven content presentation.
  • Worked with various formats of data like XML, Flat files (fixed width, delimited), Excel.
  • Lead design, Development and implementation of reporting engine procedures with Platform independent characteristics by using Oracle and XML.
  • Used SQL* Loader to upload the bulk data from formatted text /XML files into Oracle tables.
  • Developed DB packages to process XML containing EVL (Converted 834 file) from Health Exchange.
  • Maintained and enhanced Java code using Spring, XML and JMS for batch document processing.
  • Skilled in XML implementation and conversion into Oracle and SQL Server database structures.
  • Extracted data from the XML file and loaded it into the database.
  • Schedule XML feeds, reports using SQL Server Reporting Services.
  • Worked on getting XML message for Faster Internet project.
  • Generated XML files to deliver to Thompson Reuters.
  • Automated the OBIEE and XML SPY process
  • Created XML files using Oracle procedures.
  • Used XMLAGG, XMLELEMENT to retrieve data from tables.
  • Transformed end data into xml format and sends it to message queue through SSIS packages.
  • Used XMLDOM PL/SQL package to generate xml files from table data.
  • Used XML, XSLT, XAML to work with xml documents during the ETL process.
  • Used XML SPY to set up and create formats for the XML created reports.
  • Updated and developed new SSRS Reports using stored procs, TSQL querying, using, pivots, xml, cursors.

Show More

13. Complex Queries

demand arrow
high Demand
Here's how Complex Queries is used in Senior Database Developer jobs:
  • Manage multiple databases, write technically complex queries and reports, generate business documents, and develop web applications.
  • Involved in writing complex queries to generate reports as per client requests as part of production support.
  • Optimized reporting SQL to facilitate the running of complex queries in less than one minute.
  • Created stored procedure, indexes, and views using complex queries and scripting.
  • Maintained SQL scripts indexes and complex queries for analysis and extraction.
  • Performed tuning complex queries, procedure and indexing strategies.
  • Designed & rewrote complex queries & reports.
  • Involved in Performance tuning of complex queries.
  • Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.

Show More

14. C #

demand arrow
high Demand

15. ASP

demand arrow
average Demand
Here's how ASP is used in Senior Database Developer jobs:
  • Designed and implemented an XML and XSLT based database querying system hosted on IIS and accessed via ASP pages.
  • Drive data collection and transaction processing web application on full Azure cloud deployment using C# and ASP.NET.
  • Created Detail Design document for each requirement with data flows diagram and technical aspects of implementing the requirement.
  • Helped front end developers by writing C#, LINQ and designing Server controls of ASP.NET.
  • Tested and troubleshot all aspects of newly developed applications and code prior to release.
  • Will be developing Jasper reporting/analysis tools for the researchers to utilize the data warehouse.
  • Managed Internet and Intranet classic ASP and ASP.NET (C#.NET) development.
  • Review database design in architecture prospective in broader aspect and suggest the changes.
  • Proposed architecture based on Oracle, ASP and MTS on HP-Unix server.
  • Worked on the architecture of the database aspect of the solution.
  • Support all aspects of data warehousing including database development, ETL development/data integration, report development and analytical processing.
  • Implemented Server-side Validations with ASP.Net Validation Controls and Client-Side Validations with JavaScript.
  • Participated in major overhaul and conversion of stored procedures, ASP code and Crystal Reports to conform to new environment standards.
  • Led the New England and Dallas technical teams in implementing Non Hosted Landing Pages using SQL Server and ASP.Net.
  • Performed maintenance of a website used by institutions using ASP.Net, C# and SQL Server.
  • Lead author for T/SQL objects development for use in VB/ASP client server and web applications.
  • Developed test protocols and test cases to cover key aspects of Implemented functionalities.
  • Develop and maintain various C# and Vb.net applications for ASP.Net websites.
  • Created reporting data feeds using VB scripts and asp pages Also worked on business intelligence project using IBM Netezza and MicroStrategy.
  • Used AJAX Textbox Watermark, Masked Edit and Toggle Button with ASP.Net Controls.

Show More

16. DTS

demand arrow
average Demand
Here's how DTS is used in Senior Database Developer jobs:
  • Improved ETL processes by designing and developing DTS and SSIS packages as well as scripts and jobs.
  • Involved in making mappings and transformations using DTS Transform Data Task, Data Driven Query Task.
  • Developed and maintained DTS packages to load external data into SQL databases on a daily basis.
  • Utilized DTS to map, transition, import / export data for the EDI module.
  • Designed DTS packages to integrate and transform data from various source into SQL Server databases.
  • Upgraded DTS packages to SSIS, currently upgrading all packages from SSIS to SSDT.
  • Work on DTS, Import and Export utility, BCP Utility and replication tool.
  • Created DTS Package designs for Import/Export from different servers like oracle to SQL Server.
  • Limited use of DTSX/SSIS packages to migrate data from production to reporting environment.
  • Designed a number of large stored procedures and DTS packages in SQL Server.
  • Converted MS Access Database into SQL 2000 using stored procedures and DTS packages.
  • Created DTS process to transfer data from RMS system to SQL server database.
  • Performed transformations using SSIS, DTS, Bulk Insert and BCP.
  • Created DTS Package extract data from SQL Server.
  • Migrated all DTS packages into SSIS packages.
  • Migrated SQL Server 2000 to 2005, SQL Server 2005 to 2008 R2 and DTS to SSIS (ETL).
  • Created a large number of complex new DTS packages, stored procedures, user-defined functions and views; optimized existing objects.
  • Converted the Unix scripts and DTS Packages to SSIS packages Designed and developed canned reports using SSRS and Business objects.
  • Develop, maintain and monitor various ETL operations such as dataloads and postings using SQL, DTS and SSIS.
  • Converted DTS packages to SSIS during the 2000 to 2005 databases upgrade.

Show More

3 DTS Jobs

No jobs at selected location

17. DBA

demand arrow
average Demand
Here's how DBA is used in Senior Database Developer jobs:
  • Executed all required project DBA/data modeler roles except RMAN backup recover and DB install/configuration.
  • Worked with data storage, DBA and application developers to migrate all business line databases from Oracle to SQL Server.
  • Participate in the review of all database schema projects; provide feedback and identify impacts to existing environment.
  • Worked with Microsoft and DBA teams on strategic initiatives which included Disaster Recovery and Real Time Reporting.
  • Performed Query Optimization, Performance Tuning and provided DBA solutions in complete System Development Life Cycle.
  • Created the promotion package and worked with DBA to deploy the release scripts into production.
  • Performed DBA operations like creating DB, backup and recovery, SQL tuning.
  • Lead DBA responsible for assigning tasks and supervising 2 other DBA's.
  • Worked with DBA's team to create users/groups and granted appropriate permissions.
  • Work closely with Oracle DBA on physical data modeling and query optimization.
  • Provide scripts to DBA for database, table and schema creation.
  • Documented DBA standard operating procedures, policies and PL/SQL coding best-practices.
  • Performed DBA operations such as backup and recovery, SQL tuning.
  • Provided DBA support for TelBru's databases.
  • Incorporate feedback from code reviews as appropriate.
  • Coordinated with DBA in improving Database Performance.
  • Determined data rules and conducted Logical and Physical design reviews with business analysts, developers and DBAs.
  • Manage database sessions and perform DBA activities to check the sqls taking a long a time.
  • Consult with DBAs, deployment and QA to synchronize and maintain database environments.
  • Team work with SQL developers, QA and DBAs.

Show More

18. DB

demand arrow
average Demand
Here's how DB is used in Senior Database Developer jobs:
  • Converted all SQL Server, Oracle and IBM DB2 objects including table structures, stored procedures, triggers and data.
  • Involved in the project releases on Production and work with DBA to implements DB objects scripts according to the requirements.
  • Worked with DBA for creating the schema objects like Tables, Synonyms, Sequences, DB Triggers, and views.
  • Created PL/SQL scripts to extract the data from the operational database into table using DB link package.
  • Use of meetings to elicit requirements to migrate data from MySQL database to MongoDB database.
  • Contributed in making automation of sending mails to the DB owners through Perl script.
  • Experienced in real-time data transfer syncing between SQL Server, Oracle and DB2.
  • Created Shell scripts for backup/recovery strategies for Oracle, SQL Server and DB2.
  • Involved with DBA in creating Table partitioning for the critical bond tables.
  • Coded complex programs in COBOL/DB2 for building the application.
  • Support and troubleshoot very large databases (VLDB).
  • Developed conversion scripts to Oracle8i and DB2.
  • Implemented Standby Database with Data Guard.
  • Created new models and modified existing models based on the business requirements Implemented RDBMS (normalization) concepts in Data modeling.
  • Reversed engineered the oracle databases by using VISIO Worked with DBA to create the physical model and tables.
  • Worked with DBA for performance tuning of several legacy PL/SQL programs, ETL Procedures.
  • Explore other AWS database technologies like DynamoDB and Redshift.
  • Prepare the DB Rollout and Rollback plans and do the dry run.
  • Created the required process runbook which was used by other DBAs participating in the migration to AWS RDS Instances.
  • Worked on Netezza DB, developed Procedures and Netezza NZSQL and NZLOAD used in XML's.

Show More

2 DB Jobs

No jobs at selected location

19. Sybase

demand arrow
average Demand
Here's how Sybase is used in Senior Database Developer jobs:
  • Worked on replacing deprecated functions and also implemented new features of Sybase 15.5 (Backward Compatibility mode).
  • Worked with migrations of SYBASE to Oracle (specifically T-SQL to PL/SQL) Creating Unit testing documents.
  • Designed SQL databases which included merging with other systems like Sybase and Oracle.
  • Migrated Corporate Actions database from Sybase to oracle using Oracle Migration Workbench.
  • Worked on Sybase ASE 15 to Oracle 11g database migration project.
  • Restored databases from tape and monitored the Sybase error log.
  • Developed Sybase scripts, stored procedures and triggers.
  • Attended week-long Sybase System 11 Administration course.
  • Net VB programming for data migration to SAP (Sybase) using SQ LAnywhere 9.
  • Conducted PoC to evaluate Oracle Exadata as a viable candidate for replacement of Sybase IQ.
  • Involve in migrating database from Sybase 11 to Sybase 15.
  • tasked with migrating an old Sybase database with frontend application into SQL Server 2012.

Show More

2 Sybase Jobs

No jobs at selected location

20. Perl

demand arrow
average Demand
Here's how Perl is used in Senior Database Developer jobs:
  • Validated that data/business processes were properly converted and functioning as expected.
  • Modified and worked on Perl data extraction scripts, which dump the data into the database.
  • Maintained and re-factored custom ETL (Perl, Python, Bash) and data synchronization software.
  • Created batch processes and scheduling scripts using UNIX scripting and Perl.
  • Developed Perl scripts for data extraction/transformation and load (ETL).
  • Created lot of new Perl scripts and modified many existing ones.
  • Develop Unix and Perl script for data auditing and automation.
  • Developed PL/SQL Packages/Procedures/Functions/Triggers; SQL queries and Perl Scripts.
  • Developed UNIX Shell Scripts/PERL scripts.
  • Developed UNIX shell scripts and Perl scripts to process flat files from Bloomberg/NASDAQ and load data in Oracle Database and Geneva.
  • Created stored procedures to assign unique loan keys to be able to analyze origination and servicer data properly.
  • Developed the system using Perl, DBI, Sybase, Java, XML, and JasperReports.
  • Used CT/Lib extensively for database connections Used Perl to develop the end of day reports.
  • Developed in Sql Server 2000/WINBATCH/PERL/VB6.0/Crystal Reports 8.0/WINDOWS 2000.
  • Diagnose and troubleshoot Database problems and failures Written Korn, Perl, shell scripts for digitization the process.
  • Developed of migration scripts/autosys jobs in Unix Ksh/Perl/jil/JDBC.

Show More

21. Business Logic

demand arrow
average Demand
Here's how Business Logic is used in Senior Database Developer jobs:
  • Incorporated referential integrity and wrote Database triggers, procedures, functions and packages to incorporate business logic.
  • Designed the database structure and developed several complex stored procedures with extensive business logic.
  • Designed and implemented flexible data structures and business logic to support application requirements.
  • Worked on identifying and resolving data irregularities that affect Business Logic.
  • Developed unit tests to ensure database business logic functioned as designed.
  • Developed and enhanced triggers to implement business logic.
  • Developed advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
  • Create complex Stored Procedures (including Merge), User Defined Functions, Triggers, and Views for complex business logic.
  • Involved in writing stored procedures for both Online and Batch requests handling business logic and Functionality of various modules.
  • Created Shell scripts to execute stored procedures, functions and triggers to apply business logic according to user specification.
  • Created database objects like Tables, Sequences, Indexes, Triggers and Views to define the business logic.
  • Implemented complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts.
  • Designed, coded, tested and debugged business logic and custom queries per defined technical specifications.
  • Used Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
  • Involved in implementing business logic with oracle-stored procedures, functions and triggers using PL/SQL.
  • Developed SSIS packages to export and import data across environments with different business logic.
  • Developed the PL/SQL code to implement the business logic.
  • Debugged existing code for business logic issues.
  • Designed Oracle Procedures, Functions, Packages for Business logic layer Created domains, which supports Target Database data types.
  • Developed Advance PL/SQLpackages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQLNavigator.

Show More

22. Ssas

demand arrow
average Demand
Here's how Ssas is used in Senior Database Developer jobs:
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), worked on Performance tuning of SSAS Cubes.
  • Used SSAS (SQL Server Analysis Services) for designing UDM including dimension and Fact Tables.
  • Designed new data warehouse architecture in SQL Server, using SSIS, SSRS and SSAS.
  • Developed MDX cubes using SSAS and used MDX cubes as a source for SSRS reports.
  • Design, create and support Financial SSRS reports and SSAS cube for Finance projects.
  • Created Hierarchies and Attribute Relationships to force SSAS to create more Aggregation Objects.
  • Introduced Microsoft SSAS BI to company, coded cubes and dashboards.
  • Experience in designing, creating, processing of cubes using SSAS.
  • Defined specific read/process permissions for the users in SSAS instance.
  • Developed Cubes using SQL Analysis Services (SSAS).
  • Trained company in SSAS and SSRS reporting.
  • Created calculated measures in SSAS cubes.
  • Used T-SQL, SSIS, ETL, SSAS and MDX for implementation of the Project.
  • Created facts, dimensions, Calculated Measures, KPIs, Dynamic Partitions, Aggregate Designs and Custom Hierarchies in SSAS cube.
  • Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
  • Converted existing systems from Cognos to SSIS, SSAS and Excel.
  • Created cubes in SSAS to import data from relational DBs.

Show More

23. QA

demand arrow
average Demand
Here's how QA is used in Senior Database Developer jobs:
  • Involved in moving the code from DEV to System Test and to support QA team for each and every queries.
  • Coordinated with Production Release deployment and support resources to ensure the solutions get implemented smoothly into QA and Production environments.
  • Prepared the Unit Test Cases and coordinated with the QA team to test the test cases.
  • Access, evaluate, and improve quality of health care by using NCQA's HEDIS measures.
  • Designed and implemented shared environments for SQL Server/Oracle Development, QA Test/Staging and Production.
  • Worked with QA Testing group to put the new releases on the production servers.
  • Meet daily with QA and Development teams to coordinate testing and defect resolution.
  • Created a deployment scripts for QA and successfully deployed in QA environment.
  • Provided QA and production support by troubleshooting and solving the issues.
  • Code Deploy to QA, UAT environments using ARM Tool.
  • Work with QA staff to resolve defects and issues.
  • Worked on issues/tickets with QA team.
  • Completed unit testing Facilitated QA testing for users and business analysts.
  • Involved in the creation of various change control forms to promote the code from Dev, QA and to Production.
  • Composed reports for clients on solutions, QA findings, system logistics, user behavior, and data analytics.
  • Prepare database scripts for system enhancements to Dev, QA, UAT and production.
  • support Developed and coded requirements within software application for NCQA certification for HEDIS/Stars, P4P, ACO, and PCMH initiatives.
  • Completed unit testing Facilitated QA testing for users and business analysts Provided production support for all users and business lines.
  • Developed customized client reports for the analytics of QA findings, finance, sales, and workhours data.
  • Created rollout script for all the packages and objects that are to be deployed to QALAB and QFinal.

Show More

24. BI

demand arrow
average Demand
Here's how BI is used in Senior Database Developer jobs:
  • Developed sales journal report and financial reconciliation reports using oracle BI publisher/Reports 10g.
  • Experience ensuring the high availability, integrity of databases & database designing.
  • Performed RMAN, Import/Export and other database administrator responsibilities.
  • Implemented different Partition methodologies to improve performance and manageability.
  • Checked feasibility of requirement with SQL capabilities.
  • Created Alerts using Alert Manager Responsibility.
  • Maintain six (6) PL/SQL stored packages used in a custom designed Oracle based client billing system.
  • Maintain seven (7) Oracle Forms used in a custom designed Oracle based client billing system.
  • Design and develop new Oracle Forms and database objects to meet user needs and enhance system usability.
  • Combined cost, billing and marketing data to aid in projecting RPS, CPS and profitability.
  • Design SQL Server system for combined Clinical Systems reporting (Abertsons-Safeway) and capacity planning.
  • Code stored procedures, triggers and data porting applications in support of BI applications.
  • Job Responsibilities: Creating, managing and scheduling reports using crystal reports.
  • Used Bind Variables while writing Dynamic SQL to improve performance.
  • Created various types of reports using BI tool Business Objects.
  • Created single version of truth using BI tools and technologies.
  • Worked on Network performance reports involving GSM/UMTS/LTE Mobile technologies.
  • Prepared and maintaining Traceability Matrix.
  • Implemented robust ETL framework using which created end-to-end solution from designing source to BI analytics.
  • Work on 32 bit, x64 bit clustered and standalone environments.

Show More

4 BI Jobs

No jobs at selected location

25. Informatica

demand arrow
average Demand
Here's how Informatica is used in Senior Database Developer jobs:
  • Used Informatica Mapping Designer to create/update mapping using different transformations required to move data into data warehouse.
  • Design and developed complex Informatica mappings including all slowly changing dimensions.
  • Involved in the development of Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
  • Assembled subject areas and created execution plan and accommodated the new Informatica mappings.
  • Lead the team of eight Oracle SQL/PL SQL and Informatica developers at offshore.
  • Loaded the data into database tables using Informatica from text and excel files.
  • Developed/tested applications using Informatica, Oracle, Oracle PL/SQL and UNIX scripting.
  • Worked on Informatica Mapping Designer & Workflow Monitor for mapping data across heterogeneous databases.
  • Debugged existing Informatica Mappings / Workflows to identify and resolve production issues.
  • Configured and managed Informatica Repositories using Informatica administrator console.
  • Developed mapping/sessions using Informatica Powercenter 9.1.
  • Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.0.1.
  • Used Informatica mappings and workflow to load Facts and Dimension area during nightly feed.
  • Developed mappings, sessions and workflows in Informatica Power Center.
  • Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.
  • Worked on Informatica power centre tool -source analyzer, warehouse designer, mapping designer, mapplet designer and reusable transformations.
  • Used Informatica to pull data from Salesforce (Online) and CARP and migrated the data to Teradata.
  • Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
  • Worked on Informatica to copy, tranform and load data into Teradata database.
  • Created mappings using Informatica Designer and designed workflows using Workflow Manager to build DW as per business rules.

Show More

26. Linux

demand arrow
average Demand
Here's how Linux is used in Senior Database Developer jobs:
  • Installed, patched, maintained, and performed other system administration duties on Linux and CentOS platforms.
  • Configured Jenkins Jobs for new Linux Servers.
  • Configure Enterprise Management control for our Linux Create clone Oracle Instance and Databases on ASM.
  • Used Linux scripts and Oracle PL/Sql to scrub, format, and merge data in the staging area from various formats.

Show More

27. Data Analysis

demand arrow
average Demand
Here's how Data Analysis is used in Senior Database Developer jobs:
  • Developed and implemented Sales Data Analysis Enterprise solutions to improve data availability and accessibility for Pharmaceutical Sales Reps to client sites.
  • Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted table/columns as part of data analysis responsibility.
  • Lead re-engineering of application to decouple data analysis and business rules from application.
  • Preformed data analysis and visualization, resulting in overall system performance.
  • Involved in various projects related to Data Modeling and System/Data Analysis.
  • Perform Data analysis and understand Business requirements.
  • Develop End-to-End reporting solutions that include Data Analysis, Business Analysis, QA testing, ETL, using SSIS and SSRS.
  • Administered and maintained VLDB used for data analysis by creating indexes and query optimization methods for faster retrieval of data.
  • Reduced the time needed to validate data reloads by 40% by developing data analysis tools.
  • Used Discoverer 2000 to provide end users easy access to data and help in data analysis.
  • Engage actively in logical and physical modeling, data analysis and reporting tasks.
  • Worked on data analysis of Medicare, Medicaid and Commercial health plans.
  • Generated MS Access database reports and Excel macros for data analysis.
  • Maintain data warehouse for reports and data analysis.
  • Developed Quarterly customer profile reports transforming customer and transactional data for data analysis using SQL, PL/SQL and Oracle analytic functions.
  • Created ad-hoc reports for system analyst and business for data analysis
  • Worked on writing Teradata and T-SQL stored procedures and packages for data loading, reports and data analysis and validation.
  • Implement the new features in Oracle 10g such as REG_EXP and REG_INSTR in SQLs for data analysis activities.
  • Verify and approve of prcing models after careful research and detailed data analysis.

Show More

1 Data Analysis Jobs

No jobs at selected location

28. Solaris

demand arrow
average Demand
Here's how Solaris is used in Senior Database Developer jobs:
  • Installed and configured FreeTDS/UnixODBC for Linux/Solaris to MSSQL connectivity.
  • Write shell scripts on Sun Solaris 9 to move data between Drug Testing Program application and Laboratory Information Management System.
  • Executed Oracle Report migration project 11 g from 6i and Solaris to Linux.
  • Installed Oracle 9i database on Sun Solaris and AIX 5.2 Installed and configured Oracle RAC for Call Center business.
  • Managed system backups of Solaris 8 systems utilizing Legato Networker, Oracle export and custom korn shell scripts.

Show More

29. Autosys

demand arrow
average Demand
Here's how Autosys is used in Senior Database Developer jobs:
  • Developed and modified several UNIX shell scripts, and managed important AUTOSYS/CRONTAB jobs.
  • Support of Oracle Database migrations to Amazon Web Services (AWS) Developed 3rd Party file ingest process to utilizing AutoSys.
  • Perform unit testing, write project documentation, provide implementation and post implementation support Prepare and monitor AutoSys Batch Jobs.
  • Created script for archiving data feeds and deleting log/temp files older than 30 days and scheduled job using autosys.
  • Involved in scheduling oracle jobs using DBMS_JOB, DBMS_SCHEDULER & batch jobs using UNIX CRON scheduler, Autosys.
  • Developed and ran the jobs to load the data into warehouse using Autosys, Putty and UNIX.
  • Serve as expert in Oracle technology and mentor teammates in database and Autosys.
  • Created various Autosys entries for scheduling various data cleansing scripts and loading.
  • Involved in scheduling various jobs using Autosys and DBMS job scheduler.
  • Created Schedule jobs using Enterprise job scheduler (autosys).
  • Created JILs for scheduling the jobs in autosys scheduler.
  • Worked in the development framework involving Oracle 11.2, Unix, Autosys, iXp, Tortoise SVN, Atlassian JIRA.
  • Have developed JIL scripts to schedule Informatica workflows, WebFOCUS reports using Autosys.

Show More

30. Olap

demand arrow
low Demand
Here's how Olap is used in Senior Database Developer jobs:
  • Lead database design and initial phases of development of MS SQL Server OLAP database.
  • Developed fact tables, dimensional tables, cubes for OLAP warehouse using Analysis Services.
  • Maintained and enhanced the OLAP databases used to collect and aggregate email data.
  • Established OLAP Reporting servers and Crystal Report access through web browsers.
  • Designed and built OLAP cubes to meet reporting needs.
  • Created OLAP cubes using MS Analysis Services.
  • Developed OLAP databases in Essbase for a variety of applications, both financial and operational in nature.
  • Introduced and implemented Hyperion Essbase OLAP cubes for robust analytic data mining and reporting.
  • Developed Multi-dimensional, OLAP cubes as per the specifications using SQL Server Data Tools.
  • Developed OLAP Reporting System for Super Quik Inc.

Show More

31. Management System

demand arrow
low Demand
Here's how Management System is used in Senior Database Developer jobs:
  • Implemented File management system including File Validation for source.
  • Involved in development of Contract Management System.
  • Performed data storage, security, integrity, and performance management functions for Database Management Systems (DBMS) supported.
  • Assisted with the designing and planning of new functionality for an Oracle Apex Metadata management system.
  • Designed and developed an electronic interface to the Property Management system using PL/SQL and Dynamic PL/SQL.
  • Designed and developed SSIS packages to process feeds from Dealership Management Systems (DMS) systems.
  • Develop a revenue management system for UTC (Transportation Department of Washington State).
  • Court Case Management System (CCMS), Administrative Office of Courts, California.
  • Worked on Order Management Systems (OMS)and private brands systems.
  • Sole creator for EMS (Enterprise Management System).
  • Redesigned and further developed database schemas and stored procedure components for an Internet-based Student Management System.
  • Modelled and programmed Mortgage securities management systems.
  • Administratored and monitored order management system database and upgraded the reporting system database from SQL 2005 to SQL 2012
  • Utilize Kintana change management system to maintain version control of source files.
  • Focus: My SQL 5.1, Microsoft Access 2007) Setup MySQL 5.1 database management system.

Show More

32. VBA

demand arrow
low Demand
Here's how VBA is used in Senior Database Developer jobs:
  • Developed Data Transformation Services packages on SQL Server 2000 that converted VBA code for MS Excel to ActiveX Script.
  • Developed 30+ reusable VBA Scripts in Data Junction/Cosmos for data cleanup, formatting, and parsing of data fields.
  • Designed and developed 10 databases with custom user interfaces using VBA to streamline the carrier dispute process.
  • Created various VBA Applications that shared data between MS Excel, MS Access and MS PowerPoint.
  • Designed and implemented MS Access databases using VBA programming with Data Access Objects (DAO).
  • Used MS Access 2000 database and VBA to load data from flat files into SQL databases.
  • Work included SQL development, VBA development, form development and report development.
  • Created complete automation of Incentive program and Dashboard using VBA macro.
  • Supported multiple reporting applications developed in MS-ACCESS and VBA for Excel.
  • Create and debug VBA code in MS Access application.
  • Automated reports using VBA, VB.NET and SQL server.
  • Automated reports and PL tables using VBA.
  • Excel automation using VBA - macros.
  • Team lead for the OEF, DFAS, DOOR, MOR, and EDW BIRLS projects at VBA.
  • Contained VBA advanced functionality to import documents, populate related Word Documents, and produce a custom ad-hoc reporting system.
  • Created an Excel macro enabled sheet using VBA programming.
  • Designed and wrote code for front-end applications using Microsoft VBA, Action Script, Flash Remoting, ColdFusion, Dreamweaver/HTML.

Show More

33. Oltp

demand arrow
low Demand
Here's how Oltp is used in Senior Database Developer jobs:
  • Designed and developed custom OLTP database warehouses and decision-support systems.
  • Developed test modules on C, C++, bash for estimate performance in massive parallel processing OLTP environment.
  • Design web-based and client/server solutions for OLTP, batch and DSS / data warehouse systems.
  • Generated reports using SSRS SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
  • Created and managed new BackOffice and FrontOffice processes, running in OLTP based environment.
  • Supported an OLTP database with 10,000 daily trades and millions of historical trades.
  • Design and implement new OLTP databases optimized to 3NF where practical.
  • Created packages to transfer data between OLTP and OLAP databases.
  • Designed OLTP and OLAP database systems from scratch.
  • Implemented data models for OLTP and star schemas.

Show More

1 Oltp Jobs

No jobs at selected location

34. Test Cases

demand arrow
low Demand
Here's how Test Cases is used in Senior Database Developer jobs:
  • Produce comprehensive documents outlining user specifications, business processes, functional specifications, test cases and system recommendations.
  • Used TFS to work on SSIS packages, Database objects and to write unit test cases for the stored procedures written.
  • Prepare testing specifications, and create test cases to test code and query performance tune and performance test the application.
  • Involved in creation and review of CIT and SIT test cases / test plans, data validation and deployment procedures.
  • Prepared template for the test cases required for testing Oracle stored packages, procedures, Functions, and reports.
  • Involved in writing various Test Plan and Test Cases and documentation of the project.
  • Involved in testing, trouble shooting of the Application and creating the test cases.
  • Reviewed and approve test cases and test results for members of the Test Team.
  • Involved in developing test plans and test cases based on high-level and detailed designs.
  • Assisted the testing team in preparing the test cases and validation of data.
  • Developed and tested the QuickTestPro scripts for more than 1500 test cases scenarios.
  • Prepared test cases as per TSD and execute the test cases.
  • Code reviews and test cases reviews for the database team.
  • Provided estimations for PC mappings development and Unit Test cases.
  • Involved in writing the Unit Test Cases using SQL.
  • Developed testing requirements, prepare and execute test cases.
  • Prepared and executed the Unit Test Cases.
  • Developed Unit Test Cases using utPLSQL for automated testing of packages, functions and procedures.

Show More

35. Sharepoint

demand arrow
low Demand
Here's how Sharepoint is used in Senior Database Developer jobs:
  • Develop and administer SharePoint sites to support application documentation and user interfaces for the application.
  • Enabled users to self-generate reports from a list by setting up a site on the SharePoint server.
  • Deployed reports both to the SharePoint server, IIS Server, Integrated SharePoint server with Report Server.
  • Configured SSRS 2008 with MOSS 2007 for directly deploying the report in SharePoint 2007.
  • Awarded for converting Intranet site to SharePoint, facilitating company-wide collaboration, 2013.
  • Used TortiseCVS for change control and SharePoint for Project status and information.
  • Worked on SharePoint 2007 for storing the design documents and documentation.
  • Used Change man for version control and SharePoint for work Tasks.
  • Maintained metadata library in Sharepoint.
  • Charged with export, development and maintenance of SharePoint lists serving as backend for PMD application.
  • Created sharepoint forms to execute process on back-end using C#.

Show More

36. Visio

demand arrow
low Demand
Here's how Visio is used in Senior Database Developer jobs:
  • Worked with minimal supervision as an individual contributor for the Data Management and Data Administration organization.
  • Project manager coordinating two additional IT professionals in SQL scripting and modeling (T-SQL) and documentation areas (VISIO).
  • Assisted in supervision / scheduling / code review of off-shore contractors
  • Worked on Provisioning and SMPP components processing.
  • Returned to Cablevision to provide design and development expertise for a large-scale Business Intelligence Data Warehouse environment.
  • Initiate Migrations from one environment to other Worked on tools like Microsoft VISIO, Alfresco and JIRA for bug tracking.
  • Access Provisioning System is designed as a self-service tool for all Oracle employees to request accounts with built-in approval process.
  • Modified custom CGI interface written in VB5 * Created documentation and E/R diagrams with Visio.
  • Involved in creating the Data Modeling design using Visio and Erwin tools.
  • Created data models, ER diagrams, and documentation using Visio.
  • Created Architecture Diagrams, and Flow Charts using Microsoft Visio.
  • Worked on data masking using an in-house provisioning tool Alcazar.
  • worked with Enterprise Architect team to develop the physical data models Created an ER diagram in MS Visio.
  • Created data flow chart diagrams using MS Visio * Excellent Client & onsite - offshore co-ordination.
  • Net, C#,.Net applications, Visio, SSH Tool, Oracle database platforms 10g, Linux/Unix, AS400

Show More

37. Html

demand arrow
low Demand
Here's how Html is used in Senior Database Developer jobs:
  • Documented over three hundred database objects and a created user-friendly, HTML-based reference documentation set using AdeptSQL tools
  • Develop prototype HTML direct load data base application for addition product ordering/tracking.
  • Created HTML Help Files using Oracle's HeadStart Utility.
  • Created monitoring tools employing and integrating html, java script and database calls.
  • Designed the artwork using Photoshop, and converted it to CSS/HTML code.
  • Developed an HTMLDB reporting application 8.

Show More

38. DB2

demand arrow
low Demand
Here's how DB2 is used in Senior Database Developer jobs:
  • Led the development effort to create standards DB2 database accesses via Stored Procedures that could interact with newly developed COBOL source.
  • Experience in working with Host integration server in setting up connectivity between SQL server and AS400/DB2 for data insertion and selection.
  • Developed, implemented and maintained multiple relational databases using DTS technologies and linked server between SQL server and db2.
  • Developed stored procedures for production systems in SQL Server 2000, Oracle 8 and 9, and DB2.
  • Experience in integration of various data sources like SQL Server, Oracle, DB2 UDB and Flat Files.
  • Created SSIS Packages to extract data from different external sources like ORACLE views, FTP, DB2.
  • Tuned DB2 part of the batch process by partitioning the table to increase the performance.
  • Converted stored procedures from SQL server to Oracle and from Oracle to DB2.
  • Installed and configured DB2 Connect servers and cataloged AS/400 and OS/390.
  • Mentored development teams in the areas of SQL Server and DB2.
  • Migrated/Re-created SQL reports/procedures from db2 to SQL Server 2012.
  • Created Migrated Db2 UDB objects between different environments.
  • Installed and Configured DB2 UDB 8.1 on UNIX (AIX) and Windows 2000.
  • Provide support for a significant analytical DB2 application of a large financial accounting Data Warehouse/Data Mart.
  • Designed, coded and tested ETL process for loading DB2 data into Teradata using Unix shell scripting and Mainframe jobs.
  • Optimized DB2 sql by reducing the number of table reads as part of performance tuning.

Show More

1 DB2 Jobs

No jobs at selected location

39. TFS

demand arrow
low Demand
Here's how TFS is used in Senior Database Developer jobs:
  • Experienced in use of parameters, variables, and SQL Server 2012 project deployment model as well as TFS.
  • Used Team Foundation Server (TFS) for the security and version control.
  • Utilized TFS for the purpose of code check in and Agile tracking
  • Worked on Visual Studio 2012 and Synced/loaded projects with TFS 2010.
  • Used agile methodology with TFS.
  • Used TFS for file maintenance.
  • Source control: none -> TFS.

Show More

40. Tkprof

demand arrow
low Demand
Here's how Tkprof is used in Senior Database Developer jobs:
  • Involved in SQL Tuning by creation of indexes, rebuilding Indexes using Explain Plan, SQL Trace and TKPROF Tools.
  • Performed PL/SQL tuning and application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
  • Involved in Performance tuning of SQL Queries and processes using DBMS_STATS, DBMS_SQLTUNE, EXPALIN PLAN, AWR and TKPROF.
  • Tuned new queries as well as existing queries using Explain Plan, SQL Trace, AWR reports and TKPROF.
  • Tune SQL queries using EXPLAIN_PLAN and TKPROF.
  • Have done a lot of performance tuning based on Explain plan, Tkprof.
  • Worked on Performance tuning of the SQL's using Explain plan, tkproff.

Show More

41. Vb.Net

demand arrow
low Demand
Here's how Vb.Net is used in Senior Database Developer jobs:
  • Converted the legacy web system to the latest technology to ASP.NET, VB.NET and C#.
  • Constructed VB.net Web Services and used them in the SSIS Packages using Web Service Task.
  • Designed and coded VB.net reports and deployed on the company's website using Web Services.
  • Designed, implemented, and tested Web services with C#.NET and VB.NET.
  • Created multiple Desktop/WEB for user data input and reports using VB.NET and Crystal reports.
  • Converted SQL 2000 databases into SQL 2005 and widely used VB.net Web Services.
  • Designed the common framework using VB.NET Created user/custom Win forms controls.
  • Design and developing the application in ASP.NET, C#, VB.NET.
  • Developed Business Classes using VB.Net, XML.
  • Created ad-hoc queries, SSIS packages, VB Script and VB.NET, upgrading DTS from 2000 and creating cubes.
  • Used VB.Net, ADO.Net and SQL Procedures in-order to access the SQL Server Data Base for the front-end presentation.
  • Developed a number of VB.Net desktop applications and executables to run batch processes.

Show More

42. Schema

demand arrow
low Demand
Here's how Schema is used in Senior Database Developer jobs:
  • Converted logical database model into physical database schema.
  • Load balancing, databases/schema/table re-organization for faster performance.
  • Create and modify existing stored procedure, functions, trigger on database schema for updating, deleting and inserting data.
  • Designed SQL star schema data marts and cubes in SSAS to facilitate analysis of client metrics.
  • Created OLAP cubes and materialized views in Oracle schema to provide data to Data Mart.
  • Developed the Star Schema for the proposed warehouse model to meet the requirements.
  • Designed cubes with star schema using SQL Server Analysis Services (SSAS).
  • Implemented DOL schema on key tables to improve concurrency/throughput and minimize deadlocks/ blocks.
  • Work with other developers to ensure solid schema design and optimal performance.
  • Involved in Logical and Physical Database design and Star Schema design.
  • Evaluated schema release management tools including Oracle Enterprise Manager, Embarcadero Change Manager and Quest Schema Manager.
  • Involved in re-designing of database to create de-normalized reporting schema for better throughput.
  • Create and manage database schemas, users, roles, tables, views and other database objects.
  • Experience in Data Transformation and Data Mapping from source to target database schemas and also data cleansing.
  • Developed and used Dynamic SQL's in the package and procedure for publish functionality between two schemas.
  • Key Results: Created the database schema to house both CRM and MLS IDX/VOW listing data.
  • Developed data model, SQL Queries, SQL Query tuning process and Schemas.
  • Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
  • Architected and designed new database schemas and data layers, as well as maintain existing ones.
  • Redesigned the logical schema to meet the new requirements and to make it scalable in future.

Show More

8 Schema Jobs

No jobs at selected location

43. R2

demand arrow
low Demand
Here's how R2 is used in Senior Database Developer jobs:
  • Installed and configured SQL Server 2005/2008/2008(R2)/2012 on new servers with service packs.
  • Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008R2.
  • Provide support for production SQL Server 2008 and SQL Server 2008 R2 database processes.
  • Update native compilation mode for PLSQL Objects for performance tuning in oracle 11g R2.
  • Design and implement SSRS reporting configuration framework utilizing SQL Server 2008 R2 database.
  • Worked on WR218 for OEF / CTS and assisted the production deployment.
  • Developed SQL 2008 R2 within the Amazon Cloud.
  • Migrated data from SQL Server 2005 to the SQL Server 2008R2/2012 using SSIS.
  • Migrated SQL server databases from SQL 2005 to SQL 2008R2.
  • Key Projects Created, tuned, maintained and patched 11gR2 databases on Linux (Oracle Unbreakable Linux and CentOS).
  • Architected, data modeled and implemented database solution for borrower income analysis application in SQL Server 2008 R2.
  • Integrate data from various sources into Oracle (11g R2) and Netezza (V7) databases.
  • Used: SQL Server 2008 R2, SQL Server Reporting/Integaracion Service, Visual Studio 8, MS Excel
  • Created report models and deployed on report server.Deployed the SQL Server 2005/2008/2008 R2/2012 SSIS packages.
  • Created and maintained ELT quires from Postgre and SQL 2000-2008 R2 databases systems.
  • Set up Filemaker Server on Windows Server 2008 R2.

Show More

44. Sdlc

demand arrow
low Demand
Here's how Sdlc is used in Senior Database Developer jobs:
  • Participated in SDLC process including requirement gathering, development, testing, debugging, deployment, documentation and production support.
  • Configured and implemented New Request, Change Request and Bug Tracking software, incorporated SDLC model within tracking software.
  • Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC).
  • Involved in the complete SDLC process of requirements gathering/analysis, designing the application/tool, development and finally testing.
  • Prepared SDLC Documents such as High level Design Document, Technical Design Document and Test Plan.
  • Developed, documented and employed a SDLC (Software Development Life Cycle) process.
  • Understand the business requirements and implement the same in the system through SDLC.
  • Involved during entire SDLC process of any task or project assigned to me.
  • Analyzed different business requirements and provided time estimate for various SDLC phases.
  • Examined and reviewed all T-SQL and stored procedures for good SDLC practices.
  • Involved in Analysis, Database Design and Implementation for SDLC cycle.
  • Experience working with SVN and Start Team and Follow SDLC.
  • Worked within the guidelines of a solid SDLC framework.
  • Maintain SDLC of corporate Case Management System.
  • Participated in different phases of SDLC.
  • Worked with users through all Software Development Lifecycle (SDLC) phases.
  • Led agile development processes and communicated project deliverables and status to all stakeholders throughout the Software Development Lifecycle (SDLC).

Show More

45. Technical Specifications

demand arrow
low Demand
Here's how Technical Specifications is used in Senior Database Developer jobs:
  • Customized & optimized the existing stored procedures according to the Technical specifications and performed troubleshooting on the existing stored procedures.
  • Traveled to client sites to interact with clients and determine product requirements; later converted requirements into technical specifications.
  • Collected business requirements from users and translated them as technical specifications and design documents for development.
  • Collaborated with the Business Analyst team in prototyping, data profiling and writing technical specifications.
  • Transformed complex functional requirements to technical specifications and authored technical design documents for the system.
  • Translate high level BRD/FSD documentation and conceptual data models into detailed technical specifications.
  • Convert business requirements and rules into technical specifications in accordance to standards, including but not limited to, field-to-field mappings.
  • Get the functional spec reviewed by the project stakeholders and designing the Technical Specifications for architect review.
  • Conduct regular review of the Function and Technical Specifications to reflect the latest changes and enhancements.
  • Worked with BA's to create technical specifications.
  • Translate functional / technical specifications and logical data models into working databases, including relational and multi-dimensional designs.
  • Developed and maintained extensive documentation detailing conversion logic on all projects and technical specifications for APIs and transformative applications.

Show More

1 Technical Specifications Jobs

No jobs at selected location

46. Web Application

demand arrow
low Demand
Here's how Web Application is used in Senior Database Developer jobs:
  • Performed development and administration of PostgreSQL databases, in support of a Distributed Marketing Resource Management web application/platform.
  • Web application replaced time consuming manual gathering of commission data and excel reports.
  • Developed internally facing web applications and reporting solutions.
  • Developed a web application for data managers to run the ETL interfaces in Oracle Application Express (APEX).
  • Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto the web servers.
  • Web application allows users to select a specific commission cycle and execute the SSIS packages.
  • Worked on Master Pages and CSS for the layout of the web application.
  • Create reports for web applications using stored procedures and SQL 2005 Reporting services.
  • Worked on enterprise Java web application using Struts, JSP and JavaBeans.
  • Performed optimization of Stored Procedures used by ETL jobs and web applications.
  • Migrated web applications running on SQL 2000 to SQL 2005 Enterprise edition.
  • Web application contained an interface to SSRS reports on the report server.
  • Performed QA of web application.
  • Debug and optimize the performance of a high traffic, multi-tier web application
  • award during last year's HG code-a-thon for designing and implementing an Urgent Care Locator Web Application within a day.
  • Used Active Reports and SSRS to integrate reports in to .Net based web applications.
  • Supported the conversion of a multi-tiered web application from asp to .net.

Show More

1 Web Application Jobs

No jobs at selected location

47. Data Integrity

demand arrow
low Demand
Here's how Data Integrity is used in Senior Database Developer jobs:
  • Maintained data integrity, performance, security and availability of the database.
  • Communicated with users to ensure data integrity across systems.
  • Reviewed, analyzed, and performed data integrity checks on data to ensure consistency with data requirements.
  • Managed import/export of data from one database to another in case of data integrity issues.
  • Identified slow running queries and optimization of stored procedures and tested the application for performance , data integrity using SQL Profiler.

Show More

48. Javascript

demand arrow
low Demand
Here's how Javascript is used in Senior Database Developer jobs:
  • Developed JavaScript behavior code for User Interaction.
  • Enforced page validations using JavaScript and to perform validations against the database Ajax calls are used.
  • Integrated custom JavaScript code files to add functionality into the mod_plsql generated HTML pages.
  • Generate dynamic web-reports using java, Jsps, HTML, DHTML & Javascript.
  • Web Applications(C#, ASP.Net, Javascript, jQuery, Component Art, WCF Webservices) Developed FilterLayer DLL.

Show More

49. Source Code

demand arrow
low Demand
Here's how Source Code is used in Senior Database Developer jobs:
  • Followed the Change Request / Work Order process flow and installation procedures to deploy the source code in production.
  • Manage development projects using Visual Studio Team Services source code control and Agile tools.
  • Converted Oracle PRO C and reports source code to PL/SQL procedures or packages.
  • Used Tortoise CVS for configuration management of the source code and the documents.
  • Installed and administered QVCS source code control system.
  • Source Code and Release Management.
  • Source code control used Perforce.
  • Organized and migrated custom enterprise DSES Applications source code into a structured Microsoft Team Foundation Server environment.
  • Maintained source code versioning in PVCS, later in Subversion.

Show More

3 Source Code Jobs

No jobs at selected location

50. DDL

demand arrow
low Demand
Here's how DDL is used in Senior Database Developer jobs:
  • Performed database design at the object level, create DDL scripts, define database snapshots, and indexes for Oracle databases.
  • Created tables, views, sequences, triggers, table spaces, constraints and generated DDL scripts for physical implementation.
  • Developed DDL Scripts for Database Objects like Tables, Views, synonyms, sequences, Indexes etc.
  • Use Dynamic SQL and Execute_Immediate functionality to perform DDL in PL/SQL blocks and procedures.
  • Required extensive development of complex T-SQL (DML and DDL) programming code.
  • Perform DDL/DML changes in QA, DEV, Production environments.
  • Consulted on performance issues within the middle-tier and the database.
  • Designed and developed the database design and DDL scripts.
  • Build the code based on the requirements and develop middleware layer to provide data to ADP Global View.
  • Write Java beans, Servlets and Web-services to serve the middle-tier needs.
  • Create new tables and DDLs for new database objects.
  • Extracted Market Analysis Bloomberg data for specific BONDS from Bloomberg as a reference for Middle Office.

Show More

Senior Database Developer Jobs

NO RESULTS

Aw snap, no jobs found.

20 Most Common Skills For A Senior Database Developer

Pl/Sql

16.8%

SQL

11.3%

Database

10.8%

Data Warehouse

9.5%

ETL

7.1%

Ssis

5.9%

Business Requirements

4.8%

Unix

4.6%

T-Sql

3.8%

Ssrs

3.7%

Toad

3.3%

XML

2.9%

Complex Queries

2.3%

C #

2.3%

ASP

2.1%

DTS

1.9%

DBA

1.9%

DB

1.8%

Sybase

1.7%

Perl

1.6%
Show More

Typical Skill-Sets Required For A Senior Database Developer

Rank Skill
1 Pl/Sql 12.9%
2 SQL 8.7%
3 Database 8.3%
4 Data Warehouse 7.3%
5 ETL 5.4%
6 Ssis 4.5%
7 Business Requirements 3.6%
8 Unix 3.5%
9 T-Sql 2.9%
10 Ssrs 2.8%
11 Toad 2.6%
12 XML 2.2%
13 Complex Queries 1.8%
14 C # 1.7%
15 ASP 1.6%
16 DTS 1.5%
17 DBA 1.5%
18 DB 1.4%
19 Sybase 1.3%
20 Perl 1.3%
21 Business Logic 1.2%
22 Ssas 1.2%
23 QA 1.1%
24 BI 1.1%
25 Informatica 1.1%
26 Linux 0.9%
27 Data Analysis 0.9%
28 Solaris 0.9%
29 Autosys 0.9%
30 Olap 0.8%
31 Management System 0.8%
32 VBA 0.8%
33 Oltp 0.7%
34 Test Cases 0.7%
35 Sharepoint 0.7%
36 Visio 0.7%
37 Html 0.7%
38 DB2 0.7%
39 TFS 0.7%
40 Tkprof 0.7%
41 Vb.Net 0.7%
42 Schema 0.7%
43 R2 0.6%
44 Sdlc 0.6%
45 Technical Specifications 0.6%
46 Web Application 0.6%
47 Data Integrity 0.6%
48 Javascript 0.6%
49 Source Code 0.6%
50 DDL 0.5%
{[{skill.rank}]} {[{skill.name}]} {[{skill.percentageDisplay}]}%
Show More

10,579 Senior Database Developer Jobs

Where do you want to work?

To get started, tell us where you'd like to work.
Sorry, we can't find that. Please try a different city or state.