We provide IT Staff Augmentation Services!

Senior Database Developer\etl Developer Resume

SUMMARY:

  • To obtain a challenging technical position with a company that promotes knowledge, encourages hard work and provides opportunities.
  • An excellent and extensive experience with Microsoft SQL Server 2005, 2008, 2012,2014 and 2000
  • Advanced knowledge of using MS SQL Server Integration Services (SSIS)
  • Advanced knowledge of Microsoft Visual Studio
  • Advanced knowledge of SQL Server Data Tools
  • Database Mirroring, Snapshot and Always On
  • Log Shipping
  • Moderate Knowledge of Microsoft .net (VB.net and C#.net)
  • Architect, designed and developed Enterprise Databases.
  • Writing procedures, triggers, packages in PL/SQL.
  • Working with Oracle 10G Datapump Utility.
  • Backup/Restore for Oracle and SQL Server.
  • Database internals development, including query & optimization.
  • Entity - Relationship data modeling.
  • Wrote the entire triggers, stored procedures and views for each of these databases.
  • Designing, implementing and using ODBC databases (SQL Server, Access, etc.).
  • Designing and writing ANSI SQL-92 compliant statements.
  • Experienced on both Microsoft TSQL and Oracle PSQL database scripting languages.
  • Detach\Attach databases
  • SQL Server database audit
  • Optimizing queries and performance tuning
  • Generating and testing SQL Reports using RDBMS (i.e. Crystal Reports).
  • Installing, supporting, administering and managing MS SQL Server 7.0, 2000, 2005, 2008 and 2012.
  • Ability to work as part of a team, troubleshoot and resolve bugs, work under tight deadlines, research and resolve ambiguous programming situations.
  • Creative, ambitious, good at working independently and as a team member.
  • Articulate, friendly and customer oriented.
  • Strong verbal and written communications.
  • Strong technical background.
  • Take pride in all work and willing to go extra miles for the customer.
  • Database Replication
  • Data Modeling (Physical and Logical) and Data Mapping using Erwin and Embarcadero.
  • ETL experience such as working with Informatica and SSIS.
  • Designing reports using Microsoft reporting services (2005,2008,2012,2014)
  • Outstanding knowledge of T-SQL
  • PowerShell scripting

EXPERIENCE:

Confidential

Senior Database Developer\ETL Developer

Responsibilities:

  • Database development in Microsoft SQL Server 2014
  • ETL Design and development in SSIS SQL Server 2014
  • Report design in SSRS SQL Server 2014
  • Dimensional and Tabular Modeling in SSAS SQL 2014
  • Performance tuning and Optimization
  • Developing CLR and database objects
  • Data Compression and Encryption
  • Working in an agile environment
  • Database design and architecture
  • Data quality and analysis check
  • Writing procedures, triggers, functions, views etc in T-SQL.
  • Power BI (Power Pivot, Power View)

Confidential

Senior Database Architect, Developer and Administrator

Responsibilities:

  • Team leader for the Database Development team
  • Data Modeling (Physical and Logical)
  • Requirement gathering
  • Designing, physical implementation and development of the data warehouse
  • Recommendation of system architecture
  • In corporation of different data sources
  • Working with all application programmers to make sure product encompasses all business logic based on application data consumption
  • Implementation of encryption for PII data to comply security regulations of military network
  • ETL development using Microsoft SQL Server 2008 and 2012 Integration Service (SSIS)
  • Automation of ETL run based on metadata of the data sources
  • Design and Maintain Data Warehouse Metadata Management Database
  • Working with my team and others to help them understanding the new features of MSSQL 2008, MSSQL 2012 and how they can take advantage of these features in terms of performance and efficiency.
  • Performance tuning and Optimization
  • Developing CLR objects
  • Data Compression and Encryption
  • Developed Log Shipping between environments in different networks using hybrid of MSSQL Log shipping and .net through SSIS in round robin style.
  • Data Encryption and Compression
  • Assisting and advising application developers through the development life cycle
  • Troubleshooting performance bottleneck using SQL Profile, Windows Performance Monitor and Extended Event (XEvent, DMV)
  • Creating and optimizing all SQL objects e.g. procedures, triggers, tables, views etc.
  • Teaching application developers how to optimize performance of their code (queries) by using partitioned, none partitioned indexes, filtered indexes, materialized views and partitioned tables.

Confidential

Senior Database Administrator

Responsibilities:

  • Administering, developing and supporting databases on MS SQL Server 2005(32 bit and 64 bit) on Windows 2003 server platform.
  • Setting up and maintaining users, roles, and schemas for all schema objects including object level permissions
  • Created DDL events and DML triggers, stored procedures, Views, User defined function and User defined types etc.
  • Heavily used SSIS in designing and deploying packages for ETL work, to collect performance related and index statistics across all servers.
  • Upgraded existing DTS packages on MS SQL Server 2000 to SSIS packages.
  • Converted email tasks previously on MS SQL Server 2000 which required MAPI profile to DBMAIL tasks using SMTP Protocol.
  • Created and deployed reports using SSRS (SQL SERVER REPORTING SERVICES)
  • Worked on data warehousing projects using SSAS (SQL SERVER ANALYSIS SERVICES)
  • Created user defined alerts at the database server level and file and system resource level to proactively detect free space and system issues.
  • Automated repetitive management tasks with scripting. Planed, designed, and executed database administration tasks including scheduled jobs, backups, adding/modifying/deleting logins, optimizing queries.
  • Assisted over 50 application developers with database access and performance issues and backout plans
  • Extensively worked with SQL Profiler tracing and monitoring long running queries, blocking transactions, scans etc. Troubleshooting performance and debugging performance problems across all databases servers Migrated across servers for development and test environment. Set up transactional and snapshot replication. Used mirroring and database snapshot to meet user requirements for data read only

Confidential

DBA

Responsibilities:

  • Administration, developing and supporting MS SQL Server 2005 databases on Windows platform.
  • Administration, developing and supporting Oracle 10G databases on a Unix platform.
  • Supporting Data Warehouse and Maintaining subject based Data marts in MS SQL Server 2005 and Oracle 10G in both administration and development.
  • Data modeling and maintaining using Embarcadero (Staging, Data warehouse, Data marts databases) both MS SQL and Oracle 10G.
  • Writing Stored Procedures, triggers, PL/SQL Procedures and packages, User defined Functions) both MS SQL and Oracle 10G.
  • Maintaining users, roles, schemas, tables paces, all schema objects etc both in MS SQL and Oracle 10G.
  • Sizing Extents, Memory Blocks etc.
  • Maintaining user permissions and roles both in MS SQL and Oracle 10G.
  • Optimizing performance for all user queries both MS SQL and Oracle 10G.
  • Implementing partitioning in Range partitioning and composite partitioning both in MS SQL and Oracle 10G.
  • Exporting/Importing data and schema using Oracle 10g Datapump Utility.
  • Building SSIS packages to move data across environments.
  • Help troubleshoot and debug developers) both MS SQL and Oracle 10G.
  • Automate data migration from Development Data marts to Production Data marts both MS SQL and Oracle10G.
  • Built and scheduled packages using DBMS Package (DBMS Datapump) and Oracle DBMS Scheduler to schedule nightly jobs to export data.
  • Analyzing tables and updating statistics.
  • Creating local and global indexes both MS SQL and Oracle 10G optimization.
  • Backup/Restore databases both MS SQL and Oracle 10G optimization.
  • Maintained and minimized Backup space usage by building WinZip logic into the backup method.
  • Scripted in Bash shell script.
  • Scheduling jobs in Crone.
  • Used UNIX SunOS, Windows 2003 Enterprise Edition.

Confidential

DBA

Responsibilities:

  • Supporting SQL clustered environment
  • Experience in SQL Server Fulltext Indexing such as creating, maintaining, and troubleshooting fulltext indexing issues.
  • Maintaining and performance tuning several SQL server databases used by different applications
  • Data migration
  • Writing packages in DTS
  • Planned and tested Backup and Restore procedures
  • Configured databases for log shipping, using standby server
  • Data modeling and designing databases
  • Troubleshooting
  • Designing reports using Microsoft reporting services (2000, 2005)
  • Mirroring SQL databases

Confidential, CA

DBA

Responsibilities:

  • Administered MSSQL Server 7.0 and SQL Server 2000 databases
  • Optimized performance and maintained all SQL Server databases
  • Planned and tested Backup and Restore procedures
  • Configured databases for log shipping, using standby server
  • Created and maintained Data Transformation Services (DTS) for SQL Server.
  • Created and scheduled jobs for database maintenance and data refresh
  • Upgraded SQL Server 7.0 to SQL Server 2000
  • Performed Historical data Import and Export
  • Optimized performance and maintained all SQL Server databases
  • Planned and tested Backup and Restore procedures
  • Configured databases for log shipping, using standby server
  • Created and maintained Data Transformation Services (DTS) for SQL Server.
  • Created and scheduled jobs for database maintenance and data refresh
  • Upgraded SQL Server 7.0 to SQL Server 2000
  • Performed Historical data Import and Export
  • Database internals development, including query & optimization.
  • Entity-Relationship data modeling.
  • Wrote the entire triggers, stored procedures and views for each of these databases.
  • Designing, implementing and using ODBC databases (SQL Server, Access, etc.).
  • Designing and writing ANSI SQL-92 compliant statements.
  • Experienced on both Microsoft TSQL and Oracle PSQL database scripting languages.
  • Backing up\Restoring, Detach\Attach databases
  • Optimizing queries and performance tuning
  • Supported SQL Server databases more than 1TB in size.

Confidential

DBA

Responsibilities:

  • Supported Oracle 8i database as a backup DBA support.
  • Oracle 9i Release 2 Client Setup and Support
  • GemBase 6.1.5A-5 Support
  • Optimized performance and maintained all SQL Server databases
  • Planned and tested Backup and Restore procedures
  • Configured databases for log shipping, using standby server
  • Created and maintained Data Transformation Services (DTS) for SQL Server.
  • Created and scheduled jobs for database maintenance and data refresh
  • Upgraded SQL Server 7.0 to SQL Server 2000
  • Performed Historical data Import and Export
  • Supported and Administered Applications
  • Firehouse Software from Visionary
  • FM1 Innovus from Caver-Morehead
  • FRX Reporter

Confidential

DBA/Network Administrator

Responsibilities:

  • MS SQL Server 7.0 and SQL Server 2000
  • Modeled and support all corporate SQL Server databases.
  • Support and maintain the Windows 2000 network.
  • Create security for groups and roles in Windows 2000 and SQL Server.
  • Write all the default, constraints, triggers and stored procedures to support business rules.
  • Created the entire required Index (Clustered and non-clustered) on the tables for optimization.
  • Create all triggers to enforce data integrity (i.e. cascading deletes, cascading updates, etc).
  • Created all needed triggers to log all delete and update actions in the database for auditing purposes.
  • Wrote all required stored procedures for creating quarterly snapshots to support reporting.
  • Develop and code methods for transferring reposed data between multiple systems
  • Testing/Optimize all database related functions
  • Provide regular maintenance of the databases including backup and monitoring
  • Create Data Transformation Services (DTS) to move and format data
  • Write SQL Server stored procedures for all data Read/Write functions
  • Perform the analysis of old legacy code and translate to new stored procedures
  • Generate and test SQL Reports using Crystal Reports
  • Migrating data from one database to another
  • Data modeling (logical designing and physical designing)
  • Transferring in between heterogeneous databases
  • Experience in administering and developing in DB2 UDB, and in-depth experience of using Erwin and Microsoft Visio for database modeling.
  • Administering, creating large table spaces, maintaining, backing up, restoring, permissions, cataloging, and setting up schemas.
  • Importing, exporting, reverse and forward engineering between DB2 and MS SQL Server databases.
  • Backing database and restoring it to another server on a different system, migrating stored procedures and configuring federated databases.
  • Auditing all the data.
  • Setting role based security and then monitoring it.

Hire Now